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. Tables should default to "My table has headers" being ticked

    It's taken me 10 years to realise this but I've never "unchecked" My Table has headers, it's ALWAYS the other way round, forgetting to remember to tick it because Excel hasn't recognised the header row.

    Let's default the tick to always on ?

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

    We’ll send you updates on this idea

    10 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. Need to Merge Two Cells

    Need to merge 2 Cells

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  4. The "select all" checkbox should never scroll out of sight in a filter dropdown

    When I want to select one entry in a drop down filter, it happens to me frequently that I scroll down to find the entry and then discover that should have deselected "select all" first. Very annoying. That box should be independent of the rest and never scroll out of sight.

    4 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 →
  5. Create a "Table" sheet type

    Can we have a "Table" sheet type, similar to a chart sheet? It can only contain a single table with no cells outside the table, but could grow/shrink as required, and should have improved navigation / deletion / insertion capabilities

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow insert copied cells for whole rows in tables

    Allow user to use the "Insert copied cells" in a table when they have selected an entire row. This is needed to quickly replicate rows in a table. The limitation seems inconsistent with the following:
    * Users can already "Insert cut cells", just not copied cells.
    * Users can insert a blank row, then copy another row over the blank row, which is functionally equivalent but two steps.

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add F4 toggle to "lock" structured refrences

    Structured references are awesome. But making them relative/absolute is not! Let us use the F4 shortcut on structured references too.

    3 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 →
  8. 3 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 →
  9. Dependent Drop Down Lists Using a Master Table of All Possible Combinations as a Data Source

    Referencing the attached table, the idea is to have the first drop down list show "Distinct" items of the [Family] column, the second drop down list shows the corresponding items from [Product] column. this opens a wide door for utilizing Excel as an data entry system for customized solution specially for small businesses. Thank You!

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  10. Automatically Change Range Names' Spaces to Underscores

    When pasting or typing a new name into the Defined Name New Name dialog, it is faster and easier to write table names with spaces. However, spaces are not permitted in table names. Therefore, the spaces should be automagically converted to underscore characters.

    3 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. Have excel highlight a column that has an active filter. Just turn the heading yellow or something that you can easily find

    At least make it optional. There is nothing more aggravating than losing what column you have a filter on in a huge sheet and searching for it. Highlight it yellow, or allow the user to select a color.

    4 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 →
  12. Multiple values in one cell

    Provide way to enter multiple values into a single cell AND then view these as separate rows (e.g., in Pivot table or via formatted Table).

    E.g., A1 = "Banana", B1 = "Fruit, Yellow"
    Then provide way to view table that shows "Banana" TWICE (as two rows: under "Fruit" and "Yellow").

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  13. Making a directory in Word importing information from Excel.

    How can I make a directory using text information from Excel and photos? I'd like to put them in a Word Table. This needs to be updated several times a year, so would like to be able to insert information as it changes.

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  15. Show the full column name in a tooltip when the column headers have been scrolled past

    If a table cell is selected and you have scrolled down so that the column headers are not visible, the A B C column headings will be replaced with the column names. This is a great feature, but column names often span multiple lines, so the column names get cut off.

    If the user hovers over one of these column names, the full column name should appear in a tooltip. This would be especially useful for larger tables with columns that begin with the same words (e.g. Cost With Tax, Cost Without Tax).

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  16. Setting proper width when inserting Table Column

    When inserting Table Columns adjust the columns to match the width where the data came from. Make it work like it does when inserting column on spreadsheet.

    5 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 →
  17. Data sorting in Pivot tables by field rather than columns

    I use slicers to connect with multiple pivot tables showing date for multiple (2017, 2018, 2019) years and set them to sort data in descending order by 2019 column.

    Sometimes if a select a parameter on the slicer pertaining to some data which deos not exist in 2019 (a discontinued product or customer), the pivot table stops showing that year (2019, on which the sorting is set) and when the filters are removed, the sorting order also gets reset to default on all the connected pivot tables.

    It would be helpful if the sorting could be done on a field…

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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?

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  19. In Excel filtered column drop down scroll (Select All) menu should be fixed instead of scroll hide after list go scroll down

    In Excel filtered column, when i am going to select drop down and scroll the list that time (Select All) menu going scroll accordingly. If fridge or fixed the (Select All) menu list, it will more help when I go down more and more and need to check out all then have to go back again first, So it should be fixed the (Select All) menu list that will really helpful to user. Screen captured for better understanding the issue.
    Thanks

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  20. In Excel filtered column drop down scroll (Select All) menu should be fixed instead of scroll hide after list go scroll down

    In Excel filtered column, when i am going to select drop down and scroll the list that time (Select All) menu going scroll accordingly. If fridge or fixed the (Select All) menu list, it will more help when I go down more and more and need to check out all then have to go back again first, So it should be fixed the (Select All) menu list that will really helpful to user. Screen captured for better understanding the issue.
    Thanks

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

Feedback and Knowledge Base