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. Sensible date formatting on X-axis of XY-scatter charts

    If the X-axis of an XY-scatter chart is DATES, then it would be great to have the option to select the x-axis category labels to be spaced by (eg) months, years, etc like you can do for a line-chart. The advantage of being able to use an XY-scatter chart with this proposed functionality is that not all plotted series have to share the same x-series. Thank you!

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

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you your suggestion regarding x-axis date formatting of scatter charts. This suggestion has merit, however, we don’t expect to devote time to this it in the near future. We will continue to track votes and comments here.

    Thank you again,
    Auston [MSFT]

  2. Give us a "Center Across Selection" option for the Vertical text alignment

    "Center Across Selection" is available for Horizontal text alignment but not for Vertical text alignment.

    This would be useful for heading columns where the text is rotated through 90 degrees and spans more than one row.

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

    We’ll send you updates on this idea

    12 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow new chart types (treemap, sunburst, etc) to also be used as pivot charts.

    The new chart types are really interesting, however; they would be much more useful if they could also be tied to a pivot table. This would make them much more dynamic in nature.

    Along the same line, it would be very beneficial to allow the interactivity on the charts to cross filter objects tied to the same data source. For example, if I click on a department in my treemap chart it would then filter the pivot table below to only the department I clicked on.

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

    We’ll send you updates on this idea

    18 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking the time to share your suggestion to support new chart types to be used as pivot charts.

    We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We’ll continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again,
    Auston [MSFT]

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

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

    113 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 →
  6. 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 →
  7. 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.

    22 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

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

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

    We’ll send you updates on this idea

    13 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.)

    24 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 →
  10. 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 →
1 3 Next →
  • Don't see your idea?

Feedback and Knowledge Base