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 ?

    117 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. 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 →
  4. 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 →
  5. 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.

    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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. Improve the functionality of data tables:

    Improve the functionality of data tables:
    - so you can control which data tables need updating and others that don't need updating everytime you do a calculation. This would improve the performance of updating calculations where only certain aspects of the model have changed.
    - make it easier to run nested data tables

    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. 해 찾기 추가 기능 - 종속변수 활성화 체크박스 추가

    해 찾기 추가 기능에서 종속 조건 변수에서 체크 박스를 추가하여 활성화 및 비활성화 기능을 사용 할 수 있게 만들어서 활성화 시켰을 때 결과 값과 비활성화 시켰을 때 결과 값을 비교 할 수 있었으면 좋겠습니다

    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. [Accessibility] Keyboard shortcut to move rows and columns

    ALT+SHIFT+ARROW_KEY, similarly to tables in word and OneNote

    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. Excel should allow to copy & paste the values even when there is filter

    Excel should allow to copy & paste the values even when there is filter that is used. This will make our work faster, as we need not un-filter the cells to copy and paste the values. Currently we can't make range of cells static by copy pasting when there is formula in those 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 →
  16. Copy-pasting unsorted filtered data causes Excel to freeze for 2 minutes

    Copy-pasting the visible cells on a filtered selection of unsorted data causes Excel to freeze for 2 minutes before the data is pasted in a new sheet.
    However, when performing a sort first before applying the filter, the data is pasted instantaneously.

    We are running Microsoft Excel for Office 365 MSO (16.0.11328.20362) 32-bit / Click-to-run / semi-annual channel / Version 1902

    Steps to simulate the issue can be found in the attached PDF document.

    2 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 →
  17. Return refresh auto filter old style

    Please return to old-style refresh autofilter method.

    On 2016 version, it is necessary to re-aply filter to refresh the results.
    In older version, after select an item in a column, others colums was already filtered.

    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 →
  18. Excel AutoFilter

    Summa securos acie apparere dum scrolling adde transitum. Commode enim magnum lists

    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. hyperlink sorting

    in a table when I sort, the hyperlinks are locked to a cell and does not sort with the text. so if I fill in a hyperlink in cell 134 and it sorts to cell 39, the hyperlink is still linked to cell 134 and not to cell 39. Is there a way to have the hyperlink be locked to the text and not the cell so when I sort it updates cell location with the text?

    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 →
  20. Use AGGREGATE instead of SUBTOTAL for the total row of tables and for subtotals

    AGGREGATE is the successor of SUBTOTAL and all supported versions of Excel support it. There is no reason to use SUBTOTAL over AGGREGATE.

    Please use AGGREGATE instead of SUBTOTAL for the total row of tables and for subtotals (Data tab → Subtotal). Then deprecate SUBTOTAL by adding it to the list of Compatibility functions.

    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