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. Change Excel Table Name in the Create Table Window

    Every time I Insert an Excel Table I then have to go change the Table Name (Alt+J,T,A). It would be great if the Table Name could be changed on the Create Table window when you are selecting the range of the Table.

    It would also be nice to have some default settings for the table names. For example, I prefix all my table names with "tbl". This makes it a lot easier to get a list of the tables in the workbook when writing formulas. I would like to store this preference somewhere and then have the table name be…

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

    We’ll send you updates on this idea

    14 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  2. Data validation - allow Table references as List Source.

    If I'm using Data Validation in List mode, and I use a Table reference (e.g. "=Table1[Column1]") as the source, for some reason it doesn't work!

    The workaround is to create a separate named range for that Table reference (e.g. make a named range called "Table1Column1" that Refers to "=Table1[Column1]", but it's a real pain to have to do this every time, and it is something that I use a lot!

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

    We’ll send you updates on this idea

    12 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  3. primary key for rows in a table

    I'd love to have an option in a table to add an ID (record counter) field. No formulas or vba just a system generated unique number for each new row in a table. Automatic timestamp would be great too! vba could do this but making it a built-in feature would be helpful for those who want to keep it simple.

    13 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 →
  4. Pin the (Select All) check box in a filter list

    The (Select All) check box appears first in a filter list but disappears when you scroll down the list. I would prefer to see this box pinned at the top of the list so it can be checked and unchecked easily however far down the list you scroll. I often scroll down a long list then realise I wanted to deselect all and just choose one option so I have to scroll all the way back up to unchecked the box.

    30 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 →
  5. Select None Filter, move Select All to side

    Add a select None Button to the Filter box, then move this button and the select All button slightly to the left so that they always show up. That way when you are in the middle of the list and some are selected you can select all easily or remove that selection easily.

    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 →
  6. Table Sorting for both Row Data and Column Data

    For excel Tables give an option to filter both columns and rows using drop downs. This would eliminate the need for transposing. Right now, filters are only at the top row and filter column data. I would like to use this feature and then filter the row data. So there would be a drop down arrow across the top row and also filters for each row going from top to bottom in the first column of a Table.

    28 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. Data Filter drop down box should have an option to filter rows that contain formulas or not formulas

    Have as a selection in the drop down box to filter for cells with formulas or cells without formulas

    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 →
  8. Autofilter of Merged Cells

    You need to fix the filtering of merged cells to retain the entire merged cells rather than only showing the first. It simply makes no sense as is.

    If I merge say A1 through A4, and apply a filter that should return that range, it displays only A1, hiding A2 though A4?! No it is merged, thus I intentionally made it one cell, thus it should display that whole cell, not a subdivision thereof.

    I've created my own function with a button on a ribbon, but this functionality should be part of Excel's core functionality.

    Merged cells on a whole…

    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 →
  9. I wish the (Select All) checkbox would be above the scrolling list of values found. While browsing the list of values found, I find that I f

    I wish the (Select All) checkbox would be above the scrolling list of values found in a filter. While browsing the list of values found, I find that I frequently have to scroll back to the top to change the setting of Select All, then back to the value of interest to change its setting.

    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 →
  10. 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 →
  11. Provide ability to save Power Query queries/codes into a library (for reuse in diff files)

    It would be nice to be able to reuse queries, or pieces of queries in different files that need similar formatting/processing. I may want to "virtually" the same thing without always looking in a refreshed [single] file or directory.

    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 →
  12. 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 →
  13. Dynamic headings or additional header rows in tables

    This is somewhat related to
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9647427-header-selection-while-sorting

    I believe that table column headings should be dynamic (i.e. value determined by a formula), and if that's not possible, then we should at least be able to specify an arbitrary number of dynamic "subheadings". There are times that you have non-heading information that you want to put at the top of a table without having it as part of the heading. Examples include small notes or units.

    A common approach that I take in tables is to have the user choose a unit to be put in the CONVERT function. That way, I…

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

    10 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 →
  16. Allow deletion of only filtered table rows

    When a table is not filtered, you can delete a row in only the table. However, when a filter is applied, your only option is to delete the entire sheet row.

    This is quite a pain if you are filtering for invalid values that you want to delete. The current workaround is to change the cell colour of rows to delete, then unfilter, sort by colour, and delete the rows. If sorting should be avoided, then you have no choice but to move the table or everything beside it such that nothing is beside the table.

    3 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. New Randomize Function

    This function would allow a user to highlight a column and sort it randomly. Meaning the values in a column would appear in a random order after this sort is applied.

    3 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 →
  18. 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 →
  19. 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 →
  20. Allow me to copy mutiple worksheets that contain a table

    Excel will currently not let you copy more than one worksheet at a time if any of them contain a table. This needs to be allowed.

    14 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