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.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add Translate Function

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

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. can Microsoft pay us for good suggestions made

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

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Introduce Query formula with all sql capabilities

    Introduce Query formula with all sql capabilities

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Support of dynamic array formulas in tables

    Support of dynamic array formulas in tables

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow for inline macros in formulas

    Allow inline macro as in the following example format:
    Instead of :
    =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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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…

    33 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base