Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. SUMCOLS and SUMROWS functions for Dynamic Arrays

    Create new functions that SUM each column in a dynamic array (SUMCOLS(Ref#)) to produce a row of totals, and SUM each row to produce a column of totals (SUMROWS(Ref#))

    Also COUNTCOLS, COUNTROWS, AVERAGECOLS, AVERAGEROWS, but these are less important than SUMCOLS & SUMROWS.

    294 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    45 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. There is No direct command for clearing the Data Validation on the Ribbon

    Everyone is using Data Validation in Excel for simple or complex projects. However if you decide to clear your data validation rules there is No direct command on the ribbon to do that: So you have to go to the Data Tab >> Open the data Validation dialog box >> Click on Clear All >> Close the dialog Box.
    My suggestion is to integrate this functionality with the Data Validation button in the ribbon (as explained in the attached Graphic) which will enable the user with a click to either clear Data Validation from a selected range or from the…

    40 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  3. Display pivot table headers in the columns headers

    With the tables, if the header is not visible, Excel displays the headers of the table in the columns headers (see the picture attached)

    It will be great to have the same behaviour with the pivot tables

    63 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. Improve Table Design Tab Appearance and Functionality

    There is No synchronization between the Filter command on the Table Design Tab and the similar command on the Data Tab. So if you apply a Filter from the Data Tab then clear it, the corresponding Filter command on the Table Design is inactive. On the Other hand, if you insert a Slicer from the Table Design Tab ► it inactivates the Filtering commands on the Data Tab. Filter on all tabs should synchronize together as well as with the Slicer.
    Looking at the distribution of commands on the Table design Tab, I would prefer removing the Filter command from…

    19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  5. 12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Option to allow add-ins in restricted workbook (IRM)

    The new Information Rights Management (IRM) is great to protect workbooks from being opened or edited by non authorized users.
    Unfortunately it also deactivates all ad-ins. In principle this makes sense as add-ins can access and modify information within the workbook. However, current restrictions go a bit too far as even as an owner/author of the workbook with FULL CONTROL my add-ins are deactivated. Should I not have full rights to do anything with the workbook? In our company thousands of users across EMEA use a self developed add-in to calculate service costs. Now they cannot use IRM as it…

    109 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. CTRL+M to launch Power Query Editor

    Well, we know that
    the language behind Power Query is called M;
    it takes at least three clicks to launch Power Query Editor;
    the shortcut CTRL+M is currently unassigned...
    Why not using CTRL+M to launch Power Query Editor?

    115 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Product Setup and Activation  ·  Flag idea as inappropriate…  ·  Admin →
  8. Money in Excel adding subcategories

    every time I try and add a subcategory - for example - auto insurance I get

    Category changes not saved
    There was an issue saving your changes. Please try again.

    I've tried entering it under the category Auto and Bills; neither will allow me to add the subcategory. This is not just for this example. this happens EVERY TIME I TRY AND ADD ONE. ITS ANNOYING AND NEEDS TO BE FIXED

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  9. Lambda optional parameters

    Using the new lambda function, can we have the ability to put parameter names in square brackets to turn them into optional parameters for the user?
    LAMBDA(parameter1, parameter2, [parameter3])
    This would be extremely useful for reusable functions. For example, I've created a function that combines arrays, but I don't want to have limit that function to passing only a specific number of arrays or forcing the user to enter commas for the remaining criteria. Similar to index, or sumifs or other function that has optional parameters please!
    Also, if you're feeling generous, I'd love the option of hidden parameters too,…

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. SUBSTITUTES function supporting arrays of "find" and "replace" parameters

    From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.

    Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA user-defined function that performs each of the substitutions for you.

    The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the…

    135 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Right Click > Filter > Clear all

    I have a large spreadsheet which I occasionally need to filter.

    It would save me loads of time if Clear All could be added to the right click > filter options, instead of just clear the column I'm in, or reapply the filter.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  12. Excel subcells (unlimited formatting possibilities)

    Spreadsheets needs a radical improvement, no spreadsheets at the moment allows subcolumns creating subcells. This would improve the formatting dramatically. We should not have just letters, A, B, C, D... we should be able to divide these columns (letters) in subcolumns and subcells A, A1, A2... but...
    How these spreadsheets would be read? Easy.
    As they are right now (classic style).No subcolumn, no subcell, Column A, Row 2: Read: A2
    Advanced style (subcolumn and subcells), subcolumn A1 Row 2: Read A1#2
    Just columns could be divided with subcolumns, this generates a subcell (comprised with the subcolumn and the row)
    Rows…

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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…

    34 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Improving 'Refers to' Navigation in Name Manager's New Name dialog

    An accepted issue for many years, the 'Refers to:' box in the 'New Name' dialog is troublesome when you wish to edit or move within this box using the arrow keys. This is because the cell references change instead.

    Given LAMBDA is going to use this interface, and the formulae may be long (pointed out by fellow MVP Oz du Soleil), isn't it time this were fixed?

    This issue catches us all out from time to time and I struggle to see the benefit of using the arrow keys to change the cell references here.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  15. Money add-on for Canada

    Hello. I just heard about the new Money add-on for US users. Looking forward to have this available in Canada.

    18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Corrigir descrição da opção "Remover Duplicatas" no Microsoft Excel

    Corrigir descrição da opção "Remover Duplicatas" no Microsoft Excel

    No caminho Dados>Ferramentas de Dados temos a opção "Remover Duplicatas".

    "Duplicatas" no Comércio significa: "título de crédito nominativo pelo qual o comprador fica obrigado a pagar, em determinada data, a quantia correspondente à fatura de mercadoria vendida a prazo."

    Ao deixarmos o mouse na opção já aparece "Duplicatas" que está errado por fazer confusão ao comercio, e no texto em seu "balão" aparece como "Duplicadas", onde o seu único significado é "que ou o que se duplicou; que foi copiado por uso de artefato próprio ou manuscrito (diz-se de documento ou…

    115 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  17. Timespan calculus

    Currently, in cells formatted as time ([$-x-systime]h:mm:ss AM/PM), if I sum 16:00 and 12:00, I get 04:00. I would like to have the possibility of getting 28:00.

    Maybe this could be achieved through a new TimeSpan cell format that would show the absolute number of years, months, days, hours, minutes, seconds, etc. without a calendar, according to the selected format.

    So, 28:00 could, also, be shown as "1 day and 4 hours", or "1d4h", depending on the format selected by the user.

    Those TimeSpan cells would operate with other cell formats nicely. It would be possible to add a time…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. "Worksheet Sorter" for Excel

    A useful tool in PowerPoint is the "Slide Sorter" which allows you to quickly view, navigate and rearrange many slides. I think adding a "Worksheet Sorter" in Excel's "View" tab would be just as useful, and would make navigating 20+ worksheets much, much easier. If you agree with me please vote!

    101 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  19. Property in Power Query "Enable background refresh" - default to unchecked

    When creating a new query in Power Query, by default the property "Enable background refresh" is enabled. Please make this property be unchecked by default. The cases where I need this property disabled outgrow at large the cases where the background refresh can be turned on.

    20 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. Can we please get IntelliSense for LAMBDA functions?

    Add the ability to define arguement prompts when using a LAMBDA function

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    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