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. Microsoft Excel stopped working

    Hi,

    I am working on an excel with almost 1000+ columns and 10sheets. The moment I add 5columns in each sheet and then try to delete the columns again, excel stops working.

    I added the 5 columns because I needed them but later on they were not needed and I had to remove them. Each time i tried to save the file, it stopped working. I understand I have described the issue in a much simpler way but in real it is actually so much frustrating to do one simple thing multiple times that finally I thought to post it.

    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 →
  2. Correct numerical sorting of IP addresses

    We need the ability to properly sort a column of IP addresses (standard dotted decimal format: N.X.Y.Z), without requiring manual workarounds (splitting octets into separate fields and then doing multi-field sort, etc.)

    To future proof, it should understand IPv6 format as well. It needs to be smart enough to handle missing leading zeroes, and :: notation.)

    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 →
  3. Table Naming [#Headers] [#Totals] translation bug

    I am using Excel in different languages, English, Dutch and Turkish. When I open an excel file that I have created for example in Dutch, and I open this same file again in English then automatically all formulas and functions translate to the relevant formulas and functions, except for one type of functions/formulas!
    Namely all formulas contending Table references or formulas. I.e. Tab[[#Totalen];[Date]] (Dutch) does not become Tab[[#Totals];[Date]] or Tab[[#Kopteksten];[Date]] (Dutch) does not become Tab[[#Headers];[Date]] and vice versa...

    This means that you can't use conveniently Table naming for more complex usage of your excel work. Why are normal formulas and…

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

    When the filter is turned on, one should be able to see easily and quickly which column(s) is filtered, without having to scroll down or right to see which one is filtered.

    5 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. Make the Filter selection box bigger (longer), it should show at least 10 - 15 items

    Make the Filter selection box bigger (longer), it should show at least 10 - 15 items

    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 →
  6. Show count of items represented by each checkbox in the Filter dropdown menu

    When we filter we can see all the items that are present in the selected column. What would be helpful is to have next to each item the count of times it's present in that column. E.g. it column "Animal name" contains 1x"dog", 1x"cat", 5x"horse"..., if I filter, I'll be able to see the names of these animals only, what I'd like to have also is the number of times (count) they're present in the column.

    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 →
  7. Tables with rows as the headers

    Tables are really great for managing data. Sometime It would be useful if the table could have the rows as the header rather than the columns. e.g. a regular excel table but transposed.

    5 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. Have cursor default to Search cell in Filters.

    Using Filters is a two step process. Click on the Filter dropdown arrow and then selecting the type of filter desired, i.e. Search or Custom. I find that a vast majority of my filter needs use just the search function so having the cursor default to the search cell would allow me to click just once prior to typing the search criteria's vs. twice. Users desiring to use the other filter features would still by required to click a second time for their desired function and since this is no different from the current number of clicks, no harm, no…

    5 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 →
  9. Windows 10 + Excel: Fix unfilter column bug...

    When using Windows 10 and a large spreadsheet, many users of Excel 2013 and 2016 encounter problems with excel calculating extremely slowly when you remove the filter from a column. Unfiltering the same spreadsheets works fine in Windows 8.1.

    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 →
  10. Filter empty cells

    Since I usually work with long filters it would be helpful, that thick box for empty cels would be on the top. Thank you.

    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 →
  11. 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 →
  12. Add a Data Validation Manager GUI

    Determining which ranges/cells have data validation rules applied and which disconnected ranges (i.e. sets of ranges that aren't adjacent on a sheet) are managed by the same rule is currently very lacking.

    My request is the addition of a 'Data Validation Manager' analogous to the Name Manager or Conditional Formatting Manager.

    Like the Name Manager, this would show you a table of all existing sets of data validation in the workbook, what ranges the validation rules apply to, and a summary of the condition. From here you should be able to drill into specific data validation rules to modify them.

    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 →
  13. Filter typing jump to "Search"

    When opening a filter and one starts typing, the cursor should automatically jump into the "Search" box.

    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 →
  14. Please upgrade drop down list like excel web version

    Upgrade drop down list like excel web version. Excel web version drop down list is so much modern and useful.

    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 →
  15. Need to Merge Two Cells

    Need to merge 2 Cells

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

    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 →
  17. Disponibilizar opção de cálculo de mediana na tabela dinâmica

    Disponibilizar opção de cálculo de mediana na tabela dinâmica, de modo que seja possível calcular a mediana usando filtros.

    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 →
  18. 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 →
  19. Sort by designated row in a multi-row header

    PROBLEM: We continually face a problem with sorting tables (Excel and Word) if we employ two or more rows for the column headings in the table.

    DISCUSSION: First, it is not uncommon for tables to have headings of two or more rows. Often the first row includes labels that group the sub-labels in the second row and so on. However, we cannot create such headings because they disrupt the sort feature used with tables. Second, the visual or printed headings may not be conducive to the sort feature.

    As such, the user often has to use workarounds where multi-row column…

    4 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 →
  20. Search option in Recent workbooks

    Can include "Recent Search" option in the "Recent Open" to make simpler way of finding recent opened files instead of scrolling up and down. Pls give feedback if it ok.

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

Feedback and Knowledge Base