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

    47 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 →
  2. 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

    6 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 →
  3. 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
    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 →
  4. Add a total column to tables

    Currently, there is a total row that sums all of the numbers in the same column. It would be nice to have this same thing but transposed, where excel automatically adds a total column that adds everything in that respective row. I am making a manual inventory right now, and every time there is a new order I have to update the SUM function to include the new quantities.

    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 →
  5. Quick Filter (for a list of values)

    Create a filter feature where you can paste a list of values into a field and then the filter you are using will filter to all of those values.

    Sometimes I receive lists of projects or people who I need to look into for reasons that don't fit into categories captured by other columns (such as, every completed project or everyone on a certain team). Trying to filter to 20+ projects out of a list of thousands by typing in each project ID and clicking "Add Selection to Current Filter" is a pain. When I receive an email from my…

    1 vote
    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 →
  6. Multiple cells selection problem

    We select multiple cells by holding control key. But when we accidentally select a cell without holding control key, all selected cells are gone and we have to do the selection again. This is very irritating. Please add option for the same.

    8 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 →
  7. iPad create pivot table

    Please add full support for pivot table creation for IPad OS. This is a basic requirement for financial professionals such as myself. This alone would help me use the iPad as my primary work device.

    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 →
  8. Bring Sheet View to the desktop app for files saved online

    Most people in my org who filter an Excel spreadsheet saved to SharePoint or OneDrive don't use Excel Online as it is not as feature rich as the desktop app. Sheet View avoids the problem Auto Save presents when filtering for other users collaborating at the time or opening it fresh with those filters auto saved. However, Sheet View is only available on the Online version of Excel currently https://techcommunity.microsoft.com/t5/excel-blog/sheet-view-is-generally-available/ba-p/1032576.
    Can you please also bring this feature to the desktop app?

    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 →
  9. Inverse Filter

    Allow to inverse filter selection with one click.

    While analyzing data, I have have to change the filter to the opposite, to crosscheck. Depending on the formats and data quantity it can be time consuming

    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 →
  10. Tweak filter button output a bit

    When using the filter button in a column it would be helpful for two characteristics to change.

    First, after clicking on a filter and having the query window open, change the default focus to the "Search" box. At the moment there is no default so you have to move the cursor to select one anyway. That would speed up searching a filtered column greatly as it would eliminate key or mouse usage to get to the Search box.

    Second, move "(Blanks)" from the last position in the list to the second position. Again this would eliminate us having to scroll…

    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 →
  11. Change the "Filter Button" functions a bit

    When using the filter button in a column it would be helpful for two characteristics to change.

    First, after clicking on a filter and having the query window open, change the default focus to the "Search" box. At the moment there is no default so you have to move the cursor to select one anyway. That would speed up searching a filtered column greatly as it would eliminate key or mouse usage to get to the Search box.

    Second, move "(Blanks)" from the last position in the list to the second position. Again this would eliminate us having to scroll…

    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 →
  12. Bug: Tables no longer expand automatically

    In Version 2011, Build 13426.20274, and for several updates before that, Tables no longer expand when data is entered immediately below or to the right of them.

    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. Slicer multi-select option not highlighted

    Table / PivotTable slicers have 2 buttons in the title bar. The multi-select button is highlighted when selected.
    But the Multi-select command in the slicer right click context menu is NOT highlighted to indicate if the option has been selected or not

    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. When using filters on table, the ability to move onto the next part of the data using small arrow next to filter icon.

    When you filter information to make it easier to review as the information on the table is a lot, therefore you need to move onto the next part, but currently you have to go onto the icon select the next piece of data and deselect the current piece of data to review next part of info, my Suggestion is to have small arrow next to the filter icon on the table to allow you to move up or down on the next part of the data without selecting and deselecting.

    1 vote
    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. When hovering over a slicer, scroll the slicer - not the sheet

    As topic, i would be nice if when hovering over a slicer that the slicer is being scrolled and not the entire sheet (when using mouse wheel).

    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 →
  16. 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 →
  17. Make filter arrows smaller or place them on same line as headings (A, B, C, etc)

    The arrows used for filtering take up too much space.

    I end up having to make columns wider than they need to be, just so I can see the title text in the heading cell.

    Can you make the arrows much smaller, or place them in the header,
    alongside the letters?

    1 vote
    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. Add option for "natural sorting"

    Add option for "natural sorting" as present in LibreOffice.
    Should sort cells with content D15, D100, D101, D1000 in this order and not as D100, D1000, D101, D15 (text sorting).

    7 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 →
  19. Sort should work when a table is filtered

    A filtered table should reapply sorting when the "Reapply" button is clicked or Ctrl+Alt+L is pressed, but it doesn't. When the filter is cleared after using "Reapply", the rows are still not in the Sort order. This is a basic "product does not work like it should" issue.

    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. Make freeze top row work consistently when filters are also used. Has been an issue for many versions.

    Freeze Top Row, when combined with filters often leads to unexpected behavior. Today, the first row is not freezing on my sheet when I have filters enabled. There are also issues with cells not accepting focus (or at least displaying that focus has been accepted).

    1 vote
    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 →
← Previous 1 3 4 5 17 18
  • Don't see your idea?

Feedback and Knowledge Base