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

    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 →
  2. paste as linked picture disabled if range contains tables (MSXL 2007+)

    In Excel 2013 Paste as Linked Picture works for plain cells between any two different worksheets

    The issue is that Paste as Linked Picture option is unavailable if the source range contains a table (Excel 2007, 2010, 2013, 2016)

    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. Make buttons with active filter also change color (red) so that they are easily seen.

    With large tables and many columns the symbols for active filter is easily missed when columns are scrolled to find out in which column the filter is active. I suggest add color to active filter button (red). Also add item in table function to inactivate all filters with one click. That woud be great!

    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 →
  4. When inside a Table do not put "Table Tools" label in the Window Header area

    When the user activates a cell inside a table Excel shows a new ribbon tab [Design] but it also puts a pseudo tab/label above [Design] in the window header labeled as "Table Tools".

    This creates a problem for those of us maximizing the number of cells we see by collapsing the ribbon and having a lot of Quick Access buttons w/ the Quick Access toolbar in the window header because when you activate a cell inside a table the "Table Tools" label cuts off the row of quick access buttons where the "Table Tools" label starts and in the quick…

    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. Ability to Paste to Filtered Cells

    We need to have the ability to paste to filtered cells. One of the main uses cases of spreadsheet software is the ability to filter out a subset of data from a larger group and perform functions on that filtered data. Pasting data is one of the most basic, and essential operations.

    Currently the software pastes the data that we copied from only visible cells, into all cells visible and invisible. This functionality is absolutely moronic, if we wanted to paste data that way, we wouldn't have filtered it in the first place. The fact that this software can't do…

    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 →
  6. filter additional function

    filter additional function

    please check PT file

    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 →
  7. Use a formula in filter options

    Please, add an option to define the filter we want using a formula. For example, Filter has to be equal to an specific cell, this can be really usefull when we want to use some charts that can't be used with pivot tables.

    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. Search multiple entries when filtering

    At the moment you have to search one entry at a time. When dealing with part numbers etc. For an example you could be trying to apply a formula to a total of 20/100 of them. This means having to type 20 different part numbers into the search box when filtering which takes forever. I suggest that there should be a multi entry search box that you can copy and paste into when filtering as this would save so much time.

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

    When sorting data, an option to add empty rows after each data point would be helpful in order to give a better overview of the data.
    Thank 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 →
  10. Sorting

    When sorting data, an option to add empty rows after each data point would be helpful in order to give a better overview of the data.
    Thank 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 →
  11. Add option to filter drop down list

    i wants to add an option to filter drop down list which gives output as in inverse select in filter

    example: in a column i have values as 1,2,3 & 4. In a filter firstly i selected with 1 & 3 then with the help of above idea which output is select 2 & 4 in filter.

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

    We’ll send you updates on this idea

    4 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  12. Hello there! Wouldn't it be good if an option to filter a row not just an option to filter a column be included in your excel application?

    Hello there! Wouldn't it be good if an option to filter a row not just an option to filter a column be included in your excel application?

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

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

    4 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 →
  14. Table names to show up in alphabetic order in Name Box

    The Name Box is really useful for navigating around spreadsheets but Table Names show up at the bottom of the list (if there are Range Names) and also appear in the order they are created rather than in alphabetic order. Not that helpful. Please include Table Names in the list in alphabetic order.

    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 →
  15. Unable to use filters and other sorting options in view only mode of Azure Information Protection in MS Excel.

    We have some cases where there is alot of data and the user need not have Edit rights, it would become difficult for him to read the file without sorting and filtering.

    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. Get Tables working on protected sheets (add rows, sort, filter, etc.)

    I would like to be able to, under the right circumstances, have the ability to add/remove rows of a table which resides on a protected sheet.

    Currently if you protect a sheet you can't insert/delete rows of a table. Even if you unprotect all cells and allow inserting/deleting of rows on sheet protection, it doesn't matter and is completely ignored.

    What I am proposing would have to follow specific rules:

    * Table cells would have to be unprotected
    * Cells below table would have to be unprotected (truly optional † )
    * Insert Rows would have to be specified in…

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

    We’ll send you updates on this idea

    141 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  17. Create Table Dialog Box

    It would be great if there was an additional field to add a table name on creation.

    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 →
  18. Unhide all tabs

    You have the option to choose multiple tabs, and hide them in one go. It would be useful if there was an option to unhide all or multiple tabs, instead of doing them all individually.

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

    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 →
  20. Excel new Feature Request - adding new xlNotFilterValues enum to AutoFilter

    Recently, an user ask me to add a filter with a criteria that is equivalent to filter all values that are NOT in the list.

    In Excel, the only Operator enum that I can use for AutoFilter method is xlFilterValues.

    In this case, criteria must contains a list of values in a String array. I have developed some VBA code that extract in a Collection all possible distinct values that a column can contains, that remove not acceptable values and that save all these values in an array that I pass to AutoFilter(xlFilterValues) method. This work well, but it is…

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

Feedback and Knowledge Base