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. 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 →
  2. Sheet View - AutoFilter should remain for every - or until you change it in your own View

    There is a very dangerous behavior, if someone REMOVES this AutoFilter in one of theirs SheetView:
    It disappears also from EVERYWHERE - and every selection in several views is gone!!

    This happens also, if anyone changes it in "Default" - View. As this view is more like "it's the view of the latest change in any sheetView"

    I can't find any option where I could "save" my settings for this AutoFilter, or something similar - like checkbox: never remove my autofilter via change of any other view or default - per default set to Yes

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  3. shortcut to remove all filters

    easy shortcut to remove all the filters on tables in a worksheet.

    I work in finance and always filtering and unfiltering multiple columns, it would be fantastic and save so much time to have this shortcut.

    thank you
    Samantha Casey

    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

    4 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  4. Multiple Sort Views - Saved!

    I have a large sheet with thousands of rows and almost a hundred columns. It has data that is shared by several teams and each team wants to see it a different way. I resort the data for each team and send a copy out to them. I would an option to have multiple saved sorts for the data that can be stored in the same sheet. In this case, then I only send out one copy of the data. Can this be done please?

    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

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow "Custom Sorts" that you create to be saved so you can reuse without rebuilding each time

    On the Home tab, in the Editing group, click the Sort & Filter list and choose Custom Sort. Once you build a Custom Sort, allow it to be saved so that it can be reused.

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  6. display number of rows in the filter drop down for each column

    When the filter is on and you hit the carrot at the top row, a list of values in this cells is shown where you can filter out certain values. It would be great if there was a number in parenthesis that next to the value that showed how many rows were included with that value. As an example if there are 10 records that have either red or blue in that column, the list could show red (4), blue (6). Thanks!

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  7. Increase the Table Style First/Second Row Stripe Size

    The Stripe size is currently limited to 9 for table rows and columns. I have a report builder that dumps tables to excel and style formats them. A customer wanted me to change to alternating style to 10 (the data contains repeated groups of 10) rows and i found out it's capped at 9 in excel. The limit seems rather arbitrary so it would be nice if excel supported up to a 100 or something higher.

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  8. floating slicers

    I have a spreadsheet which spans around 100 columns and 500 rows.

    I have a slicer to quickly filter the information I need to see, but, if I scroll away from where the slicer is placed, it becomes lost as it is anchored to the spreadsheet rather than floating above it.

    Please could you add an option to either anchor or float the slicers (i.e. don't only have one option, please give us the functionality to choose if we want our slicers anchored or to float).

    If the slicer floats, then I could scroll anywhere on the sheet and would…

    3 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  9. Provide drop down list of columns where filters are applied with column's alphabetical label in brackets.

    This ties in with recommendations of others where they recommend changing the color of the filter button to easily identify filtered columns. Also consider providing drop down option or pop up option to list column names (with alphabetical label of column, such as (A), (B), etc). This will help to easily identify columns where filters are applied. You don't necessarily want to go to each column, but rather want to catch up with the logic / thought process you were busy with. Maybe some short abbreviated info about the values filtered as well.

    50 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow columns of text and numeric text.

    Manufacturers item codes may be numeric only or mixed alphanumeric, possibly with symbols. When a column is formatted as text, I do not want the numeric text sorted as numbers.

    10
    104
    1041
    1041T
    1042
    I cannot control the manufacturer's codes. I just want my data to be displayed sensibly. Adding \ or " interferes with the sort order.

    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

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  11. Make filter option also using the bold or unbold etc,.

    As we have filter option using the color, it would be great if we have filter option using bold or unbold text format also.

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  12. Create a feature in tables that allow a column to be used as a primary key like in a SQL database

    Allow to define a column as the table entries ID (the primary key), which would be written automatically as an autoincremented number when more entries were written.
    This would not be a formula, but a real number, preventing changes while ordering the data or deleting rows.

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  13. When moving columns in table keep original column widths across the entire table

    When I move a table column, the widths of columns to the right do not keep their original column width... or column grouping. I would like column widths and grouping keep values as they were before moving column

    2 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. Protect and Hide sheets while still allowing Tables to grow.

    Protect and Hide sheets while still allowing Tables to grow in length as data is added.

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  15. Please allow for "My Data Has Headers" to be set as a preference for all workbooks.

    Please allow for "My Data Has Headers" to be set as a preference for all workbooks. Currently this option defaults to being unchecked. 99% of the time, my data has headers and I'd rather not have to go through the steps of checking this box for every workbook I open. Others may prefer this default, so my suggestion is to let it be a preference option.

    2 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  16. move empty criteria in filters from the bottom to the top

    move empty criteria in filters from the bottom to the top. some of the special criterias like show all are on the top of the filter list. could you please move the criteria "empty" as well to the top of the list? thank you

    3 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  17. dropdown list search

    When we put Dropdown list function to a cell it should provide the quick search feature.
    Now in drop down we have to scroll down to the name or data that we are looking at.
    If there is a dynamic search attached, we can type in few letters or words of the line that we are searching and the lists that matches with the data will be shown down.
    eg: if we have 100 names of the staff in a dropdown list and we start typing the first name of the person all the people who has same name in…

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  18. Relocate the "empty" option at the beginning of the selection.

    I suggest that in the column header arrow the option "empty" be placed at the beginning.
    In the current formatting this option is at the end, in a table with many fields the selection of this option would be much more agile and productive if it were at the beginning.

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  19. Rotate comma separated data in a row to a column

    Rotate comma separated data in a row to a column

    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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  20. Clear All Filters for a table

    These days most worksheets have a lot of columns and are used collaboratively. As a result various users can put filters on columns of their choice, and when I see the worksheet I need to go clear all the filters to be able to see the full data. Instead of having to go to each column to clear its filter, I would rather have a single button or context/menu option to clear all filters.

    5 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 20 21
  • Don't see your idea?

Feedback and Knowledge Base