Feedback by UserVoice

# Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. ## Should introduce facility of a range like (\$A\$5:\$A) in function, just like Google Sheets.

Should introduce the facility of giving a range in function (for example \$A\$5:\$A) just like Google Sheets. Array formula will automatically expand to the desired number of rows.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Add Translate Function as like as google sheet googletranslate function. it is very applicable if you add it in Mirosoft Excel. Thank you.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## Add new Function called Extract

Hello,
My suggestion is to add a Function called "Extract" which can address many kinds of extractions.
Suggested formula will extract Text between nth occurrences of c1 and c2 respectively.

=Extract(A1,c1,c2,n1,n2,D)
A1 = Cell containing Text.
c1 = Character1
c2 = Character2
n1 = Nth Number of occurrence of the Character1
n2 = Nth Number of occurrence of the Character2.
D = Direction. R is Right to Left. L or Unspecified is Left to Right.

Text in A1 = “This is a good [or Better] idea; [Best] in-fact!”

Formula: =Extract(A1,"[","]",1,1)
Result: or Better
Discription: Extracted text from 1st bracket. That…

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## Watch window

In watch window after adding some cells when completing the task, I intent to select new cells for watch window to avoid confusion with old selection I wish to delete the old selection for that we have to delete each row from the old selection, if we have an option to clear all in one click it will be easy to continue with new selection of cells

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## Watch window

In watch window after adding some cells when completing the purpose for those cells, we intent to select new cells for watch window to avoid confusion with old selection I wish to delete the old selection for that we have to delete each row from the old selection, if we have an option to clear all in one click it will be easy to with continue with new selection of cells

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## Dialogue box for functions and equations

Instead of writing the function in an Excel cell, then we use abbreviations ctrl + G & ctrl + D
I suggest creating a command when selecting it. A dialog box appears in which the name of the function and the range of cells we want the function to be applied to

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## can Microsoft pay us for good suggestions made

Can Microsoft pay us for good suggestions for improving Ms Excel usability?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## Include unique,countunique and countuniqueifs functions

Please include unique,countunique and countuniqueifs function in excel. remove duplicates is also good. But it is not useful if data is changing.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Please extend FIND and SEARCH Function to search from right to left. Also if possible add a unction to reverse string.

Please extend FIND and SEARCH Function to search from right to left. Also if possible add a function to reverse string.

Thee 2 important and basic functions are missing

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

10. ## Formula Auto complete feature like Google sheet

Please introduce formula auto complete feature like Google sheet, this saves tons of time while creating dashboards.

Auto complete means, if i type the below formula and hit enter:

=iferror(if(vlookup(A2, B:B, 1, 0)=1, 1, 2

Google sheet will auto close all brackets and consider iferror as blank without me specifying.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## Accounts in Money in Excel are not appearing on my Net Worth worksheet

Many of my accounts in Money in Excel are not appearing on my Net Worth worksheet. How can I fix this issue? 8.1.2020

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## Introduce Query formula with all sql capabilities

Introduce Query formula with all sql capabilities

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## Support of dynamic array formulas in tables

Support of dynamic array formulas in tables

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## Distribution and locked cells

It is quite unconvenient that when you try to distribute a formula within a column/row, if one cell is locked then the formula is not distributed to...the whole selection.
Instead, it would very convenient that the formula was distributed to every cells selected except for the locked ones.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## the features which are a part of the tool bar are not visible unless they are saerched for e.g. insert object

in the office 365 (and probably others too), there are some features not visible on the tool bar in excel. Since the users of older versions are aware of it, they use the search feature to find it and use. e.g. the insert object can only be found when searched on the tool bar. Even though some feature is not used often, doesn't mean its less relevant at times of need. If there are more features and not fitting in the tool bar, then you can provide an option to expand that section - which was available earlier and it…

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## microsoft is a billion doller organisation. Do you pay for good Ms Excell suggestions for improving the usability? .

Microsoft is a billion dollar organization. It is suggested that MS pays for good suggestions forwarded by users to further improve its usability and thereby its sales.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Allow for inline macros in formulas

Allow inline macro as in the following example format:
=if (expression > 0, "na", "found: " & expression)

Allow for inline macro:
=#define z=expression# if (z > 0, "na", "found: " & z)

This will reduce keystrokes and errors, especially when typing long expressions that need to be repeated in a function.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## compare data in two columns like word compares two documents.

It would compare each cell with the adjacent one and show differences. you would select the first column and then select the one to be compared to. Then you could track changes and see the differences. This would help to compare long lists of text, logic or other information.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## Correção na documentação da função SOMA

Correção na documentação da função SOMA.

Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## Persoonlijke Formules in fx aanvullen welke via zelfgemaakte VBA Functions worden aangeroepen

In VBA wordt als volgt dan opgenomen:

1. Naam van de functie en bij welke onderdeel deze toebehoort;

2. Functienaam(celA1;celA2;celA3) of Range Functienaam(celA1:celA3) of Unity Range Functienaam(celA1:celA3;celB1:celB3;celC1:celC3;...);

3. Beschrijving toevoegen, welke wordt geporteerd naar de fx functie lijst.

1 vote