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. Auto Protect/Lock Dynamic Table After New Entry

    Microsoft Excel my goal is to make the whole sheet uneditable and editable both at the same time.

    For instance, I'm using Table1 and with every new entry, one row adds up in the table, but the whole table is prone to risk of being mistakenly or deliberately removed/edited. I want to make a new entry (which will add a new row, aa usual) but the whole should remain protected/locked (unchangeable). Have i conveyed my point?

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

    We’ll send you updates on this idea

    3 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  2. Enable to sort separate range columns in latest desktop version of Excel

    Trying to sort out multiple columns in Excel but received an error!! This is possible on earlier versions of Excel desktop. Need to sort multiple columns at once.

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

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  3. Total row at the top of a table

    If you filter your data with the intention of updating the total row of your table, you won't see the change until you scroll to the bottom of your table.

    Others have suggested adding a "bottom freeze pane" to always keep the total row in view. Better idea: have an option to put the total row at the top of the table, just underneath the headers.

    One advantage over "bottom freeze pane" is that you can have multiple, different-sized tables side-by-side and have their total rows align. Also, since filtering and the total row go together functionally, they should also…

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

    We’ll send you updates on this idea

    8 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  4. Marking values presented more that once in filter window

    While working with purchase specifications, the same positions in differens rows often appear with different quantities in each row which should be summed up for sending a request. It would be very convenient to have values corresponding with more then one rows marked by font, color, etc. in filter window…

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

    We’ll send you updates on this idea

    6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. Excel new Feature Request - adding new xlNotFilterValues enum to AutoFilter

    Recently, an user ask me to add a filter with a criteria that is equivalent to filter all values that are NOT in the list.

    In Excel, the only Operator enum that I can use for AutoFilter method is xlFilterValues.

    In this case, criteria must contains a list of values in a String array. I have developed some VBA code that extract in a Collection all possible distinct values that a column can contains, that remove not acceptable values and that save all these values in an array that I pass to AutoFilter(xlFilterValues) method. This work well, but it is…

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

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  6. primary key for rows in a table

    I'd love to have an option in a table to add an ID (record counter) field. No formulas or vba just a system generated unique number for each new row in a table. Automatic timestamp would be great too! vba could do this but making it a built-in feature would be helpful for those who want to keep it simple.

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

    We’ll send you updates on this idea

    5 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow me to copy mutiple worksheets that contain a table

    Excel will currently not let you copy more than one worksheet at a time if any of them contain a table. This needs to be allowed.

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

    We’ll send you updates on this idea

    2 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  8. Resize Table by double-click

    Something, you have to resize the area of your table when you manually import or delete data in a Table.

    Currently, you have 2 options to resize your Table:
    - With the button Resize Table
    - By drag and drop of the delimiter of the Table (it looks like a triangle) to adjust to the size of the data

    My idea is to double-click on this Table delimiter to adjust automatically to the area of the data (rows and columns). This means that the table would automatically extend or contract to include new data or exclude empty rows/columns.

    What do…

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

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  9. Highlight selected filter in autofilter

    When a filter is applied to a spreadsheet, the line number display changes to blue, to indicate that only a subset is displayed. It would be helpful to also change the colour of the filter button (downward arrow) for the column(s) that have an active filter.

    The icon on the button changes from a downward arrow to a funnel symbol, but that is not very well visible on a small display. The two symbols have similar shapes. It would be helpful to also change the colour to blue, same as for the remaining rows.

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

    We’ll send you updates on this idea

    2 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  10. Give the option to copy removed duplicates

    As a user, add an option to copy the removed duplicates (ribbon data / remove duplicates) to another location. Could be a new generated sheet or a location to copy them

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

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  11. Enable mouse scroll after opening Filter drop down menu

    Session: Enable filter on a large amount of data. Select drop down menu (presumes that the entries in the drop down menu require scrolling to view). Mouse wheel scroll. Nothing happens (FAIL).

    Expectation: After opening filter drop down menu, the application should be aware of mouse location and enable scrolling immediately.

    Note: User can click inside the menu (carefully as to not select something, or select then deselect), and then mouse wheel scroll functions. It should be smarter.

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

    We’ll send you updates on this idea

    3 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  12. Keep last size of Filter drop-down menu

    You should consider a way to keep the last size user set for the Filter drop-down menu - it's quite annoying having to resize it every time you open it to see more items or longer names - even if you opened the same filter for the same column repeatedly before.

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

    We’ll send you updates on this idea

    4 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  13. When I use the filter function, I would like "Blank" to be on the top, rather than the bottom of the filter window.

    When I use the filter function, I would like "Blank" to be on the top, rather than the bottom of the filter window!!!

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

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add a Reverse Selection option

    Often I apply a filter for say 10 of the 25 items to analyse.
    The next thing I want to do is filter for the not yet filtered items (so the other 15 out of 25 items).
    Now I have to do this manually.
    I really like the Reverse Selection option (like in Windows Explorer) to be added to Excel.
    In the attached file I added a screendump of Windows Explorer with this option but this is in Dutch. I think in English the commands are Select All, Select Nothing and Reverse Selection.

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

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  15. Filtering

    I work extensively in Excel, and run across a couple of things that I believe would be better served if they were rearranged.

    1) Filters:

    A. My primary idea for this is to move the “Blanks” check box to the top of the list. I often wish to filter only the blanks, and find it a little aggravating to have to scroll to the bottom of the list to select this.

    B. The ability to filter non-adjacent columns.

    C. The ability to create a custom filter that could include multiple columns of data simultaneously.

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

    We’ll send you updates on this idea

    4 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  16. 3. Excel - Using Filters – Filters start with “Select All” but “Select blanks” is at the end. When running through data you are quite often

    Excel - Using Filters – Filters start with “Select All” but “Select blanks” is at the end. When running through data you are quite often looking for blanks to add data and need to go to end of long filter list to select – put select blanks next to Select all at the front of the list. - also please pin at top to always in view

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

    We’ll send you updates on this idea

    2 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  17. Table names to show up in alphabetic order in Name Box

    The Name Box is really useful for navigating around spreadsheets but Table Names show up at the bottom of the list (if there are Range Names) and also appear in the order they are created rather than in alphabetic order. Not that helpful. Please include Table Names in the list in alphabetic order.

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

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow the naming of multiple sort criteria

    I often need to look at my data a couple of different ways. To do this I'm forced to re-enter the sort criteria for each way. It would be great if I could define the sort criteria and save it with a title. When opening the sort dialog I could select one of the saved sorts rather than defining the sort rules from scratch.

    This would also address the issue where the sort criteria spuriously comes up empty when I select certain rows but not others.

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

    We’ll send you updates on this idea

    3 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  19. other languges then english

    I use hebrew as a second language. and when i try to auto fill, excel doesn't understand to auto fill hebrew alphabet, months, days of week etc. i guess that the same problem applies to users of other second languages.
    it would be a great idea for excel to improve that. especially for right to left languages where its very important
    thanks
    i hope you will improve it the fastest possible

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

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  20. Vertical Autofilter

    Excel allows you to use a horizontal autofilter, the same procedure could be applied to vertical autofilter.

    The procedure already exists in relation to the horizontal direction, the vertical's solution could be similar.

    Visual design may be the same, only the triangle should be rotated 90 degrees to the right.

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

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base