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.

    45 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

    4 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 →
  3. 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?

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

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

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

    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 →
  8. Allow Numerical Values in the Header Row of Tables

    Allow numbers in the header row of tables.

    Right now, header rows appear to be forced to be text types.

    Allowing headers to be values would allow the use of the XLOOKUP function on the header row using the "exact or next less" and "exact or greater" flags. This would greatly simplify step-wise lookups and interpolations where the data was arranged in a horizontal fashion.

    Right now, data tables need to be arranged vertically in order to use these flags on the "header" information if the header information is a number.

    It can be done, but in circumstances where data…

    2 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 →
  9. 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 →
  10. Table from image

    Table from image - which is available on phones should also be made available for desktop app.

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

    9 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 →
  12. Sorting rules deleted when data is deleted... NOT GOOD!

    Not much of an idea but more of a feedback. The sorting rules are being deleted after data is deleted is not an improvement. I would prefer being able to manipulate my data without the worry of my rules being affected. Especially upon removal of all data to input a new set.

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

    6 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. Excel for Money - Enable sorting for columns on transactions tab

    The fields on the transactions tab allow filtering but not SORTING of transactions. Allowing them to be sorted by any of the various fields (amount, account, institution, etc.) would be very helpful.

    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. Put "Blanks" at the top of the drop-down filter list

    Currently "Blanks" appears at the bottom of the drop-down list. It would be helpful if it appeared at the top of that list. That way if you were searching for an entry, with the intent of keying it if it was missing, you wouldn't have to go to the bottom of a potentially long list to get to "Blanks".

    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 →
  16. Does anyone know of another program that does simple sorting?

    Does anyone know of another program that does even simple sorting. Excel is a bust for me without this. Does Word do it?

    1 vote
    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 →
  17. 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?

    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 →
  18. Consistent behavior when copying entire rows with active filter

    While working with Excel I encountered inconsistent behavior when copying entire rows while having active filters. The problem occurs when some columns are hidden. Copying an entire row which include some hidden columns does copy hidden and visible cells. If now a filter is applied and active the behavior changes: Now hidden cells in a row are not copied anymore. This has been tested on Office 2016 (16.0.5044.1000) and Office 365. I have tested on multiple machines with multiple users and was always able to reproduce this. During further testing I noticed that this can only be reproduced on Windows…

    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. remove duplicate column

    Remove duplicate column option. Within Excel we already have the ability to remove duplicate rows (within one ore more columns … though we do not have the ability to remove duplicate columns (within one or ore rows).

    We also have the ability to transpose data, though would rather not have to 1st transpose data in order to then remove duplicates.

    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. Search functionality in a combo box with multiple cols.

    How do I create a macro that looks for a string in combo box columns data and show only matching results in excel.

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

Feedback and Knowledge Base