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. Create an array to store data for filtering

    I have created code to collect data from any Excel source and store it in an array. I am then able to filter for that data in the same or any other Excel filter list. The data I collected does not have to be in single row or column and does not have to be in adjacent cells.

    I store this code in a hidden workbook that is opened in my Start directory. This allows the code to be available in all Excel workbooks and in other applications such as SAP.

    This ability to easily collect and filter for data…

    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. enable sorting by different year types (academic = august to july, tax = april 6 to april 5 etc)

    Hi, I work for a university and use pivot tables regularly (I realise I have posted this in Tables, Sorting and Filtering - it's the better place for the suggestion).

    I can sort by date however this is in an absolute chronological array only.

    It would be great if we could structure tables etc so that 1st August was at the top and July 31st was at the bottom.

    Similarly, if we could sort by tax year (the uk tax year runs from 6th april to 5th april the following year) that would be very useful.

    Thanks,
    Su

    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. Enable adding a Worksheet into a Shape Object

    Enable the ability to Insert a Worksheet Shape Object into a worksheet and to enable the Worksheet Object to be grouped with other shape objects and charts.

    By enabling a Worksheet shape object (even better, a workbook shape object), all the formatting and behaviors available to a regular worksheet (or workbook) could float along with the shape (or chart).
    This would add a new capability to better define and visualize the associated with charts and other shapes.

    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. Ability to paste to filtered (visible) cells

    PROBLEM: Excel's PASTE (ctrl-V) operation does not distinguish between filtered and unfiltered cells, even though its COPY (ctrl-C) operation copies filtered (visible) cells.

    SOLUTIONS:
    * Enhance PASTE SPECIAL (ctrl-alt-V) to support the ability to paste into only filtered (visible) cells.
    * Add a user option to support this default PASTE action.

    BENEFITS:
    * Eliminates the danger of pasting into a filtered area without realizing the problem. This is a very common problem with users new to Excel. Even experienced users must be constantly aware of this problem.
    * Addresses a problem for which there is no good workaround. All VBA…

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

    We’ll send you updates on this idea

    11 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    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 →
  6. Targeting a first sum of similar sums.

    The dial on the excel spreadsheet a bit antiquated. I scroll sums of about 60k or more. The upper and lower dial could be increased speed (center being a moderate slower speed) makes problem resolution faster.

    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. Please add "Show selected items" button in filter. It will help in finding selected items in a large list of items.

    Please add "Show selected items" button in filter. It will help in finding selected items in a large list of items.

    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. filter view: place filter text box above a filtered list to easily show what a spreadsheet is filtered to

    I have a spreadsheet which I'm filtering (i know I could use a pivot table but in this case that's not what I want).

    Every time I want to add a filter item I click the filter down arrow, which opens a text box and a series of values with checkboxes to add or remove these.

    When we make a list filtered, could you please add a box, perhaps above the filter line, that shows what that column is filtering to? Perhaps this box could also be used instead of having to click the down arrow to open the filter…

    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. List counted cells

    I have been searching the web for a way to list the cells that has been counted with countIf so that i can then print the data from those cells to make it easier to keep track of which numbers are remaining (a list to cross out details that have been made) Does it make any sense? Also sometimes you have counted cells and just want to see which cells are counted.

    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. 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 →
  11. Allow slicers to dock

    I use slicers with a fairly big table which results in the being either on top of the data or just out of sight. If they could dock to for example the right side of the screen (like the pivot table options do) and also snap together. It would be a very welcome addition.

    Thank you

    2 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 →
  12. 2 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. I would like the Filter data in a table or range feature list to be customizable to display a specific number of entries

    I would like the Filter data in a table or range feature list to be customizable to display a specific number of entries rather than or in addition to defaulting back each time it is used to a fixed length. It is annoying having to expand or scroll down the list each time.

    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. table heading item count

    When clicking on a table heading, for example to select items in that column, it would be great to see a count beside each listed item. I realise that this could carry a performance hit, so perhaps it could be selected as an Advanced Option.

    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. 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. absolute reffernces in table formulas -be able to click F4 for absolute refference

    I want to be able to write a formula with absolute reference with the excel table formulas the same way as with the regular formulas ( F4 OR TYPING $$)

    2 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 →
  17. 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 →
  18. lock cloumns together

    cells A1:A5 are merged, cells B1:B5 are sub categories of info in the merged cell. This is repeated for A6:A10, A11:A15, etc. I want to sort column B so that column A stays put, but the sub category info sorts while staying connected to the merged cells. For instance, A1:A5 have the letter "A" in the merged cell. B1:B5 have A,B,C,D,E dispersed through them, then A6:a10 has a "B" with B5:B10 havign a letter in each of those cells, and so on. I want to sort column B in alphabetical order while clomn A stays in it's current order, or…

    3 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 table not affect other veiws

    Allow multiple people to sort and filter a table with their own view. Currently there can only be one view at a time meaning several people can't sort and filter in their own way at a time.

    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. Data validation rules do not extend while adding new rows in a table.

    While formulas in columns extend with new rows added to a table, data validation rules do not. That's unintuitive and very inconvenient.

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

Feedback and Knowledge Base