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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. Have resize handles on all corners of tables

    Currently, there is a resize handle only on the bottom right corner of the table, and this can be clicked and dragged to expand the table downwards or rightwards, but not both simultaneously. We need a resize handle on the left to allow for easy leftwards expansion, and we need resize handles on top because a developer will likely spend more time on top naming, moving, and resizing columns than on the bottom adding new data.

    To address these cases, please add resize handles on all corners of tables. These will also make it more obvious that the range is…

    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. Fire sheet change event when last row of Excel table is deleted (ListObject VBA)

    Currently when there's only one row left in an Excel Table (ListObject) and you delete the whole row, the Worksheet_Change event is not fired.

    Request: Please make it raise the event.

    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 →
  15. Table Styles to include "LASTROW" formatting similar to "LASTCOLUMN" format

    I would like the ability to define the format for the LASTROW of a Table. There are currently options for LASTCOLUMN and TOTALROW.

    The reason for this request is that I have used DAX to populate a standard table (not Pivot Table) from my Data Model. The LASTROW of the DAX query includes total calculations using SUMMARIZE function. I would like to format the last row if the number of ROW is increased or decreased when the report is run.

    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. add wild card character for numbers only

    add wild card character for numbers only - better filter options, when letters and numbers are both in cells.
    for that i would also add a way to filter capital letters.

    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. Apply Timelines to original tables, not just pivots, and also add a weekly filter option

    I've been looking for about a month for an ability to track my shifts and tip info (i'm a server/bartender) that will allow me to filter my data by weekly, bi-weekly, monthly and yearly in an organized and clean manner. I've looked at time/shift tracking apps, spreadsheet programs of the like for WEEKS.
    I thought I FINALLY found a solution (not exactly in the way I wish) or so I thought...
    why on earth in the myriad of date filters and manner of which to apply them is there never a WEEKLY option (this week, last week and next week…

    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 →
  18. Allow insert copied cells for whole rows in tables

    Allow user to use the "Insert copied cells" in a table when they have selected an entire row. This is needed to quickly replicate rows in a table. The limitation seems inconsistent with the following:
    * Users can already "Insert cut cells", just not copied cells.
    * Users can insert a blank row, then copy another row over the blank row, which is functionally equivalent but two steps.

    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 →
  19. Selecionar datas não sequencias na Linha do Tempo

    Algo que eu acho muito útil com a segmentação de dados é a opção de poder selecionar dados independentes para ver os comparativos de forma gráfica. Por exemplo, eu posso selecionar apenas os dados de Janeiro e Setembro para comparar. Porém, se eu quiser usar a ferramenta de linha do tempo, eu sou obrigado a selecionar todo o intervalo que vai de Janeiro até Setembro, e não apenas os 2 meses. Acredito que seja algo que vai ajudar muito os usuários.

    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. Allow Excel to use the Filter Criteria as variables.

    As said in the headline - Allow Excel to use the Filter Criteria as variables. E.g. If I filter Column A on a date (maybe "Apples") then allow me to use that Filter as a variable elsewhere e.g. =IF(FILTERA="Apples","YEP","NOPE").

    This should be enabled on multiple columns e.g. any filtered column.

    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