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. 2 Ideas for Filtering

    1) Please add a functionality to "invert selection". Often you want to filter a couple of lines and after that check the remainder. It would be nice to have a one-click-solution for that.
    2) Please add functionality to "filter from cliboard". If you want to filter by various attributes you should be able to copy them from your list and add the copied lines to the filter.

    22 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 →
  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. 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

    16 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 →
  4. 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.

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

    We’ll send you updates on this idea

    7 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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 →
  6. Horizontal filtering

    ONE VERY USEFUL feature is still lacking: "HORIZONTAL FILTERING" - i.e. ability to filter, hide, sort, ONLY COLUMS which fulfil certain criteria.
    Grouping works both for columns and rows...
    Hiding works both for columns and rows...
    Filtering works only for columns - maybe it is time to go from 1D to 2D?

    14 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 →
  7. 14 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 →
  8. 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.

    14 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 →
  9. 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 →
  10. 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!!!

    13 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 →
  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.

    13 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 →
  12. 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 →
  13. 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 →
  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.

    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 →
  15. 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 →
  16. 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.

    12 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 →
  17. 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

    12 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 →
  18. Allow Dynamic Array Spill Range in official Excel Table

    It would be great if we can insert dynamic array formulas in official excel table, currently its not supported.
    Wonder what in the world can happen if we can use Dynamic Array functions like FILTER/UNIQUE in an auto expanding and auto collapsing excel tables. This will AUTOMATE lots of work in a single feature.
    Please consider the request.

    11 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 →
  19. Ability to r-organize pinned Excel files on the taskbar

    Excel is pinned to my taskbar...I would like to re-organize any Excel file that I have also pinned to the taskbar in alphabetical order.

    11 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. 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.

    10 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 →
  • Don't see your idea?

Feedback and Knowledge Base