Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. What-if Data Table calc should use multi-threading

    Calculation Performance of iterative what-if Data Tables is unnecessarily slow. The reasons seem to be (in priority sequence):
    - each iteration is using single-threaded recalculation rather than multi-threaded
    - the overhead for the whole table calculation looks larger than it should be
    - the process starts with a recalc, then does each iteration, then ends with a recalc: the first recalc is unnecessary
    - if the values to be used in one of the iterations are the same as the start values the recalc for that set of values could be skipped

    97 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Many thanks Charles for analyzing and raising this issue! Also, many thanx to folks for voting as well. Please continue to vote for this issue if it’s important to you so we can prioritize it appropriately in the future.

    Thanx,
    Prash [MS Excel]

  3. Conditional format coloring for Treemap chart

    I noticed that the new charts for 2016 have a treemap chart that looks great but is missing other options to have changes in color as oppose to one solid color for different category. Looking to have something that would change color due to changes in value (ie. from negative (red) to positive (green) with an optional midpoint color (black))

    73 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for the suggestion on conditional format coloring for treemap charts! While we don’t expect to devote time to this in the near future, we will continue tracking votes and comments here. We will keep this suggestion under consideration for future development.

    Thank you again,
    Auston [MSFT]

  4. Creation of PPT slides directly from excel Sheet

    Hi All,

    I would like to see a new feature in excel, where from just one click we can export the excel sheet , charts ,objects in powerpoint slides.

    Regards,
    Rajender

    100 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for taking the time to share your suggestion to create PowerPoint slides directly from an Excel Sheet!

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

    Thank you again,
    Auston [MSFT]

  5. Watermark

    Add a Watermark Tool with the same functionality as MS Word

    59 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    22 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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!

    86 votes

    We're glad you're here

    Please sign in to leave feedback

    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]

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

    63 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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.

    145 votes

    We're glad you're here

    Please sign in to leave feedback

    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]

  9. Add vertical waterfall chart in Excel 2016

    Add vertical waterfall chart in Excel 2016 (labels in Y axis) in addition to the existing horizontal type (labels in X axis)

    Add optional lines between bar gap

    73 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for your suggestion to support vertical waterfall charts in Excel. While we don’t expect to devote time to support this in the near future, we will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again, and please continue to share your thoughts!

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

    45 votes

    We're glad you're here

    Please sign in to leave feedback

    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.

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

    115 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    21 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add a zoom feature to charts

    In any line chart sometimes the lines are so close that we can not see the differences. Especially when we add one (or more) trend lines.

    At this point we need to zoom into the chart.

    71 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for your suggestion to add a zoom feature to charts! There are currently no plans to devote time to support this in the near future. However, we will continue tracking votes and comments, and will keep this suggestion under consideration for future development.

    Thank you again, and please keep sharing your thoughts!
    Auston [MSFT]

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

    26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  14. Do not chart null values

    Chart defaults to plotting null or ' values as zero. The default should be to not plot null values

    73 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for your suggestion! While there are currently no plans for changing the default behavior, you can modify your settings to not plot null values in your chart. You can do this by navigating to the Chart Design ribbon and opening the Select Data dialogue. From there, select “Hidden and Empty Cells” and then choose to show empty cells as gaps.

    Thank you again,
    Auston [MSFT]

  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.

    23 votes

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    25 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Fiscal Year

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

    20 votes

    We're glad you're here

    Please sign in to leave feedback

    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