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. Show "Blanks" and "N/A#" at the top and bottom of Filter lists or 'stick pin' them

    It's a pain navigating to the bottom of a list to deselect N/A or Blanks and sometimes you forget to do it so it would be really helpful if they were shown at both the top and bottom of a filter list - or, better still, 'stick pin' them in the top of the dialogue box so they can be de/selected at any time

    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 →
  2. option for labeling a group

    For example, if i have a small range of columns that relate to fees, and I group these togather, then i can assign a label Fees to this, and just use this for any calculus

    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 →
  3. Power Query / Edit a query in advanced editor directly in Excel

    As a user, allow me to use the power query "advanced editor" directly in Excel's interface so people that know the M language can speed up the process of modifying the queries and see the results without entering the power query editor.

    For example, you could clic on Excel Ribbon's:
    Data/Get & transform/Show queries
    -> right click one of the workbook's queries and there find the option "Advance editor"
    -> the advanced editor window would open, without opening the whole Power Query window
    -> change the query's code
    -> click save and load
    -> see the changes without leaving the…

    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 →
  4. Allow re-ordering columns of filtered table

    Have you ever had this happen to you?

    You just finish filtering a large table, so exactly the records of interest are displayed. However, the columns now of most interest are not next to each other, so you try to move the entire column next to each other. Excel throws an error saying it can't reorder columns of a filtered table. HUH?

    This is a long-time problem. It's just plain silly that this hasn't been fixed yet. When a table has any sort of filter applied, Excel refuses to allow re-ordering of the columns of data. The only workaround appears…

    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 →
  5. Apply Subtotals to a Table

    It would be nice to apply Subtotals to a Table. Currently, you have to convert a Table back to a Range, and then apply Subtotals.

    When you convert a Range to a Table, the Sort/Filter arrows become available automatically and makes it convenient. You also have to sort data to apply Subtotals. It is seems to me that it would be good to have to the two features (Tables and Subtotals) work together.

    6 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 →
  6. Dynamic searching in the Filter mode like in Google

    Dynamic searching in the Filter mode like in Google

    Nowadays every second is very important working with Excel. I have watched one video in youtube where one guy invented how to make dynamic searching and select the item by writing text in it like google search. He show this invention with Developer tools. But I believe that this tool can built-in in the filter mode. Currently filter works when i write the full word in the box and press enter. The new one option could provide more interactive approach to filter items.

    See video how this guy did it in…

    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 →
  7. Table cells cannot be merged.

    You have to convert the table into a normal range of cells in order to merge cells.

    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 →
  8. Header selection while sorting

    While sorting data after selecting all cells in sheet, allow us to specify how many rows at the top constitute the header and should not be sorted.

    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 →
  9. Add Sort Option to sort 'blank/no value' cells first or last

    Please add a sort option where the user can specify if they want blank cells sorted at the beginning or the end.

    When sorting it doesn't matter if ascending or descending is selected, currently blank cells always sort at the bottom of the table. I'd like to see the ability for the user to select if they want blank cells in a table sorted at first. Attached is a perfect place to put it.

    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 →
  10. Setting proper width when inserting Table Column

    When inserting Table Columns adjust the columns to match the width where the data came from. Make it work like it does when inserting column on spreadsheet.

    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 →
  11. Return to original row in table after applying and clearing filter

    After applying a filter to a table and reviewing/editing the filtered data, clearing the filter should take you back to your starting row.

    At the moment it usually takes you back to the top of the table, though sometimes it seems to pick a random row. I'm normally working at the bottom of the table.

    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 →
  12. My suggestion is to have additional TOGGLE command or feature in MS EXCEL while putting filter.

    Greetings!!

    My suggestion is to have additional TOGGLE command or feature in MS EXCEL while putting filter. One can put filter to available fields for example A, B, C, D and E. When I put filter to A and B, and then I want to put TOGGLE filter like C, D and E, it's time consuming. This new TOGGLE feature or command will be really helpful when there will be large number of data. Example showing short data with five numbers only. 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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  13. Alphanumeric sorting

    Can't we sort things by number and letter at the same time? For instance 01, 02, 02a, 02ac, 03, 07, 07a, 07d, 08a51, 08a52, 08b11, 10b67a...
    you get the picture.

    Why are we locked in to only numbers listed first, and then numbers with letters?

    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 →
  14. change formula of calculated column without overwriting all cells

    Often when using tables it is convenient to have a calculated column providing default values. I also want to have the ability to overwrite specific cells within that column with fixed values or other formulas. All of this is possible however once overwritten values have been made it is impossible to change the default formula without overwriting all of the manually entered cells with the new default formula. What I would like is a way to update the default formula (and have it automatically replace all cells using the old default formula) without having to overwrite the manually entered cells.

    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 →
  15. Increase Locked Table Length

    Please PLEASE allow tables to expand when the sheet is locked! At the moment I have had to write code to unprotect the sheet, expand the table, and reprotect! This is labourious and time consuming. Implement this option to make tables even more powerful!

    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. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?

Feedback and Knowledge Base