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. Filtering: Show count in filter box and add navigation buttons

    Filtering:

    When filter button is pressed on any column, the drop down menu should -


    1. Show number of recurrences of each unique value displayed in the drop down list, in brackets on the right side of each unique value, in grey font. This will be very helpful in knowing, by just dropping down filter menu, how many records are there for each of unique values shown in the filter drop down list. Currently we have to filter each value and run a countif formula in a help column or look at the bottom line that shows how many records are…

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

    We’ll send you updates on this idea

    6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  2. VLookup and Inserting Columns: VLookup should increment the col_index_num when you insert a new column in the range.

    When you insert a column and it affects the range referred to by a vlookup, the table range updates but the column index number does not. The column index number should increase with the table range so that the same column is pulled. I can't think of a scenario where inserting columns in a table but not updating the column index is a user's intended course of action.

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

    We’ll send you updates on this idea

    9 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Since the XLOOKUP function is now available in Excel to O365 subscribers, we recommend using it to accomplish what you need to do. With XLOOKUP, there’s no index number. You provide a range reference, so it will automatically adjust if you insert a column that causes the range to move.

  3. Pin worksheet tab

    I would like a simple option to allow you to pin worksheets so they are always available in the workbook irrespective of the number of worksheets there are.

    I.e. when you right click the worksheet tab there is an option to pin so you can quickly gain access when you have a large number of worksheets.

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

    We’ll send you updates on this idea

    10 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  4. When using Find (ctrl-F) and the found cell is selected, highlight the found text in the cell

    When using Find (ctrl-F) and the found cell is selected, highlight the found text in the cell. If the cell contains a lot of text, highlighting the searched for text will make review much faster

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

    We’ll send you updates on this idea

    11 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fix the "There's a problem with the clipboard" issue

    The issue with "There's a problem with the clipboard..." while copy and pasting is still as issue. I was using Office 2010 and there was no problem. I am now using Office 365 and this issue is prevalent. It manifests itself when pasting a value from a cell containing a formula and disappears when disabling Live Preview. I was able to copy and paste "normal" cell contents fine before the error message appears so the official response of "another program has locked the clipboard" doesn't really hold up. It looks more like Excel has locked the clipboard from itself.

    There…

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

    We’ll send you updates on this idea

    50 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for “there’s a problem with the clipboard” issue. I think this refers to this error dialog: “There’s a problem with the clipboard, but you can still paste your content within this workbook."

    When Excel shows this dialog after a copy (CTRL+C) action, it means that another app has a lock on the system clipboard. In this situation you can still paste within Excel. However you cannot paste to another app like Word or Outlook which uses the clipboard.

    A while ago we made some improvements for Office365 users so that this error message only shows once per Excel instance. This was based on customer feedback – the design change prevents it popping up multiple successive times when the clipboard is locked. We have also considered never showing the error dialog, but there was user feedback that this message is informative and helpful in some cases.

  6. recent filters

    Have a Control with the most recent filters (last 5 to 10 filters), so the filters can be reapplied to an existing table.

    This should enable power users to work faster and Archive more in Excel.

    37 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 →
  7. Enable Merged Cell Sorting

    For rows or columns that contain merged cells, all rows or columns associated with the merged cells should be treated and sorted as 1 row or column.

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

    We’ll send you updates on this idea

    7 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  8. Filtered Columns - change colour of icon

    When a filter is applied in a header row, the filtered column(s) gets a "Funnel" icon to indicate that it has been filtered. In a row where multiple filters have been applied, if, in addition to having the funnel icon, the "filtered" icons came in a different colour - say a limited choice of colours for the user to pick from - then that would make the filtered columns easier to spot. For a user looking for the first time at a file and wanting to find what columns have been filtered, having the "filtered" icons in a different colour…

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

    We’ll send you updates on this idea

    5 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Open multiple files with the same file name

    Allow excel to open files with the same name but different location at the same time

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

    We’ll send you updates on this idea

    4 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for your suggestion! Unfortunately we will not be able to address this in the near future. We’ll keep tracking the voting.

    The reason you can’t have 2 workbooks open with the same name is due to the way that linked workbooks are managed. If you have multiple workbooks open and you create a link between them, Excel shows the filename of the linked file. If there are 2 workbooks with the same name, then the formula would be ambiguous. You can read more about how Excel manages external links here – https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel.

  10. Enable Excel to send a Task to Outlook

    Some users use Excel for tracking of various tasks or operational reviews. At the end, follow-up minutes and tasks will have to be created. It would be great to have a function like in OneNote to create a Task in Outlook. Information about Due Date and Assignee should be embeddable into the cell with a little popup window.
    When in Outlook, you should be able to click the task and go back to the Excel document (and specific cell) stored on the SharePoint.

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

    We’ll send you updates on this idea

    3 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking your time to suggest and vote for this feature. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Excel Team

  11. Enable Headers and Footers to include variables based on a cell reference

    It would be great if a cell reference could be used within a header and/or footer

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

    We’ll send you updates on this idea

    6 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  12. Freeze pane for bottom row(s) of a range

    It would be good to be able to freeze one or more bottom lines (as well as the headers) of a range or table to be able to keep things like totals in view at all times.
    Similarly, freezing columns on the right hand side of the sheet would be useful sometimes.

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

    We’ll send you updates on this idea

    5 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  13. Improve visibility of highlighted cell when using Find (Ctrl-F)

    I find the highlighting of Find's search results inadeqaute.

    I often have to scan up and down the screen several times before I spot the selected cell. Please make it so that the user's eye is more readily drawn to the cell / search result.

    (I know this suggestion is similar to https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9060307-when-using-find-ctrl-f-and-the-found-cell-is-sel , but that one proposes a solution, which may or may not be the right approach. This post is just to highlight the issue. How, exactly, it gets solved, I will leave to the professionals.)

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

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Make the Go To box SCALABLE

    Formulas / Trace Dependents / make the resulting list box SCALABLE.

    It is 100% useless if the full name of the referenced cells cannot be seen in their entirety, which is usually the case.

    I know others have been asking for this for YEARS.

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

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  15. Alphabetically sort sheets/worksheets in a workbook

    When working with large data sets, I often ended up with 50+ sheets of data, and each sheet was named by a given convention. To my knowledge, there isn't a way to sort them alphanumerically without a macro. Giving the user the ability to sort so that a1 is first then a2,b1,b2,etc rather than having to sort by hand or use a macro would be seriously amazing.

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

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for suggesting this. We do think there is value in this idea, but we don’t think that we’ll be able to devote time to it in the near future. We’ll keep tracking the votes on this.

    -Eric Patterson
    Excel Program Manager

  16. Fiscal Year

    In options, have the ability to use a fiscal year setting.

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

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
2 Next →
  • Don't see your idea?

Feedback and Knowledge Base