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

  2. Worksheet groupings

    Workbooks with many worksheets can be difficult to navigate. One poster has suggested having multiple levels to the worksheet tabs.

    As an extension to this, we could have worksheet groupings where several worksheets could be contained within a grouping. You could then select a particular grouping (which would look like worksheet tabs and be placed below the actual worksheet tabs) and then have access to all the worksheets in that particular grouping. There would also be an 'All' grouping that contained all the worksheets.

    These grouping could be included in the workbook protection so that you could choose which worksheet…

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

    We’ll send you updates on this idea

    21 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. 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.

    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  ·  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. When our plans are updated we will re-open voting and you will be notified.

    -Eric Patterson
    Excel Program Manager

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

    10 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for “when using Find (ctrl-F) and the found cell is selected, highlight the found text in the cell”. While this is a nice suggestion, we are not able to work on this soon. Should we update our plans around this area, this item will be reopened for voting and you will be notified.

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

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