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

    Need a template for doing a Civil War timeline. I have events that occurred between 1860 and 1865. There are over 20,000 events I currently have in a MS Access database. MS Project can not handle dates that far back. Having a timeline would help visualize the chain of events. The events last from one day to several months.

    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 →
  2. Two Way Header Lookup Formula for Data Tables.

    Given a table result (I.e. lowest hotel price) there should be a simple look up formula that returns the column header (Name of Hotel), and another that returns the row header (Date). Index-Match can be used to find the column only if you can isolate the row and vice versa. This can be done but it is currently a complex combination of formulas.

    =INDEX($B$16:$AE$16,,SUMPRODUCT(($B$17:$AE$25=$B$28)*(COLUMN($B$16:$AE$16)-COLUMN($A$16))))

    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 →
  3. Enable to cut rows in a filtered list when shared on onedrive

    This does work when the file is not a shared file, but once it is shared, you cannot normally cut rows from a filtered list in the dekstop app.

    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 →
  4. Advance Filter for dates of a month for all years

    There is no option in advance filter unlike regular filter to insert criteria like "all dates of a month for all years". If there is any, please guide me.

    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 →
  5. Allow filtering to be turned off for particular columns in a table

    Applying a filter to a table, it applies the drop down filter to all columns. Sometimes it makes so sense to be able to filter on a particular column, so allow an option to exclude a column from being filtered on.

    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 →
  6. Trailing Date Filters

    Add trailing ("Past") date filters. These are different from the "Last" filters.

    On 6/15/2019, the "Last Year" is 1/1/2018 - 12/31/2018. The "Past Year" is 6/15/2018 - 6/15/2019. "Last Month" is 5/1/2019 - 5/31/2019. "Past Month" is 5/15/2019 - 6/15/2019.

    This can apply all the common ranges: Past X days / weeks / months / years.

    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 →
  7. When copying formulas between tables have option to keep formula intact (and not refer to old table)

    Currently when you copy columns with formulas from one table to another the formulas are adjusted to still refer to the old table columns, even if the new table has all the same column names.

    I would like the option (possibly in Paste Special) to just copy the formulas as is so that they refer to the new table (and not have to change them afterwards with a search and replace as we do now).

    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 →
  8. Make it *easy* to show *all* rows after someone else's annoying filter, ie clear filters easily

    Make it easy to show all rows after someone else's annoying filter, ie clear filters easily

    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 →
  9. CIDR Sorting

    To have the ability to sort a column by CIDR (Classless Inter-Domain Routing), so it is easier to sort a column containing IP addresses or IP addresse masks.

    Database like PostgreSQL provide such feature and it is missing in Excel without having to code

    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 →
  10. Is it possible to use " Filter horizontally " it will help to collapse or expand data in horizontal & vertical direction

    Is it possible to use " Filter horizontally " it will help to collapse or expand data in horizontal & vertical direction

    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 →
  11. When filtering. i.s.o clicking on each item to be filtered, rather click and slide over the items to select or deselect

    When filtering a list containing a large number of selection items, in stead of clicking on the items one by one (to select or deselect), rather hold click and slide over the items to select or deselect. Will save me hours of time in a year. I may just buy you a Pepsi if you get it right :-)

    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. When spilling information carry the formats of the numbers in the spill range

    When spilling information from one sheet to another, the formats of the cells do not carry over.

    I'm on a live updating spending tracker with stat spill tables that auto fill. I also have a huge Grand Totals sheet where I can over look all ov my months. When spilling the information from one sheet to another, only the values show on the second sheet. Meaning currency, percentage, etc.

    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 →
  13. HEY ASSFACES AT MICROSOFT- GET YOUR ******* USELESS CHART ELEMENTS POPUP OUT OF MY FACE. FUCK_YOU.

    HEY ASSFACES AT MICROSOFT- GET YOUR ******* USELESS CHART ELEMENTS POPUP OUT OF MY FACE. FUCK_YOU.

    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. Provide Search Box, Filter as you type.

    Provide search box for official Excel Table. It is there in Header filtering but it would be nice if there will be option for a separate search box. Search box should act like this :
    As soon as we start typing characters in search box, it starts filtering matching values in that table column and display only those row(s) which contains typed characters. This feature would make it easy to search entries in large data set.

    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. Allow creation of excel slicers in dropdown format similar to powerbi.

    PowerBi has slicers that can be presented in a drop-down format as well. A similar feature in Excel would be wonderful.

    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. Visualize and easily resize the AutoFilter range

    When you turn on the AutoFilter (accessible through Home tab → Sort & Filter → Filter or Data tab → Filter), you know that the top of AutoFilter range is the row with the filter buttons, and the AutoFilter range spans only the columns that have filter buttons. However, you cannot tell where the bottom of the AutoFilter range is just by looking.

    This issue arises when people simply select a cell in their data rather than select all of their data, and then turn the AutoFilter on, but their data contains a blank row. Then the user gets confused as to…

    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 →
  17. 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 →
  18. Filter 10000 column

    While using "Filter" features in some excel version there is a limit of only 10000 unique column, which in some cases are very less. It must be same for all version where there is no limit

    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. When a sorted column is modified, remove the sort arrow from its filter button

    When a column is sorted, its filter button will show a sort arrow to reflect this. This arrow persists even when the column is modified in ways that break the sort (edit/recalculate column values, manually reorder rows, add new rows). This can be misleading to newcomers, who would assume that the sort arrow indicates that the column IS sorted and not that the column WAS sorted.

    To eliminate this confusion, please remove the sort arrow if any edit is made to the column or if the column recalculates. This way, the sort arrow's presence indicates that the column is sorted,…

    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. Possibility to move the "total row" to the top of a table

    If I have slicers and time lines on top of the table, it would be great to show the total row on top of the table

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

Feedback and Knowledge Base