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

    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 →
  2. Vertical Autofilter

    Excel allows you to use a horizontal autofilter, the same procedure could be applied to vertical autofilter.

    The procedure already exists in relation to the horizontal direction, the vertical's solution could be similar.

    Visual design may be the same, only the triangle should be rotated 90 degrees to the right.

    8 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 currency data type to the new Data Types

    Add Currencies to the new Data Types along with Stocks and Geography so we can get current exchange rates, symbols, etc. for various currencies.

    8 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 →
  4. Unique Filtering

    Hi there

    I haven't looked at Excel from office 2016 as yet, but I've noticed that there doesn't seem to be a 'quick' unique function on Excel 2013

    As far as I can tell, still the only way to find unique records is through advanced search and is - at least in my opinion somewhat fiddly!

    My idea is, I would have thought that you could perhaps add another option on Quick Filter/Text Filter called 'Unique' just after the 'Custom Filter' option?

    Many thanks

    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. Filtering - Why does it snap back to A1?

    When turning on filtering in a worksheet, you are automatically snapped back to A1. Typically, I turn on filtering near the column I want to filter. It's more time consuming to be at the column I want to filter and then be snapped back to the beginning, only to be left looking for that column again. Can we have the ability to turn on filtering without the snap back to A1? Thanks!

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

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

    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 →
  8. Allow to add filter to a new column without removing exiting filter for other columns

    (Excel 2016) Assume you have a few columns with the filter turned on. Then
    1. you insert a new column which has no filter.
    2. you select this column and click Data -> Filter
    3. Excel removes all existing filters, the second click on Data -> Filter applies the filter to the selected column.

    On Step 3 Excel should NOT remove the existing filters

    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 →
  9. Filter for more than one Cell colour should be able (set ticks (=haken) before each colour

    Filter for more than one Cell colour should be able (set ticks (=haken) before each colour

    I want to filter out (or sort, or calculate) not only for one colour...
    Example: I'll see each Grey and each blue cell but not White cells.

    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 →
  10. Use Slicer for Table and Pivot Table

    I'd love for a slicer to be attached to both a pivot table and the table the pivot table is based upon. Couldn't find a way to do this in report connections.

    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 →
  11. Drop down list

    If you want to make a drop down box in Excel you have to enter the data somewhere in the file and select this data to insert it in the drop down list. It would be easier if you can ad values wihtout having to put them somewhere in Excel.

    7 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. Advanced Filter to copy to another worksheet/tab

    When performing an Advanced Filter and Copying to Another Location, you cannot extract the data to another worksheet. You have to perform the operation on the same sheet as the data. It would be nice to export the advance filtered data to another worksheet or even workbook! Many a time, I have to send that extraction to someone else as an email attachment.

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

    We’ll send you updates on this idea

    5 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  13. Sort tabs

    Sort tabs
    To sort worksheet tabs in alphabetical order. Want to be able to right click on a worksheet tab and choose Sort.

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

    6 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 →
  16. Filter by Cell Color - ALL Colored Cells

    Right now, you can filter by a single color or no color, but you cannot filter for ALL colored cells. In my mind, it is the same concept as filtering out the blanks and leaving all cells with values. If you are looking at the picture I attached, I want to be able to see the peach and blue rows at the same time, without the white.

    6 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. "Custom View" in worksheets containing tables

    I hate having to chose between the functionality of a table and the ability to simplify views for people who use the spreadsheet for different purposes and want to see only certain columns.

    6 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 →
  18. Indication of filtered columns

    When working with data sets with multiple columns, sometimes it is painful to find out which column I have filter applied on, particularly if you do not want to cancel all of them (basically scrolling left/right looking for those little icons) Maybe some popup window or "Go To" feature that would point you to what columns are being filtered.

    Thanks a lot :)

    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 →
  19. Data validation rules do not extend while adding new rows in a table.

    While formulas in columns extend with new rows added to a table, data validation rules do not. That's unintuitive and very inconvenient.

    6 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 →
  20. Save a custom sort

    I think it would be beneficial if there was an option to save a custom sort

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

Feedback and Knowledge Base