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.

• 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…

Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the great suggestion to make filtered columns more visible. Unfortunately we will not be able to address this in the near future. We will update this item and re-open voting if our plans change.
-Sharon

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):
- 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

Signed in as (Sign out)

We’ll send you updates on this idea

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

Signed in as (Sign out)

We’ll send you updates on this idea

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

Signed in as (Sign out)

We’ll send you updates on this idea

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

Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the suggestion about watermark support! Unfortunately, we won’t be able to address this now. We’ll keep tracking the votes for it.
-Sharon

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!

Signed in as (Sign out)

We’ll send you updates on this idea

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.

Signed in as (Sign out)

We’ll send you updates on this idea

Thank you for taking the time to vote for “Give us a ‘center across selection’ option for the vertical text alignment”. While we see merit in this idea, we are not able to work on this in the near future.

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.

Signed in as (Sign out)

We’ll send you updates on this idea

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

Signed in as (Sign out)

We’ll send you updates on this idea

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.

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.

Signed in as (Sign out)

We’ll send you updates on this idea

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…

Signed in as (Sign out)

We’ll send you updates on this idea

This is a great suggestion – thank you. Unfortunately we don’t think we will be able to address worksheet grouping in the near future. We’ll keep tracking the voting.
-Sharon

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.

Signed in as (Sign out)

We’ll send you updates on this idea

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.

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.

Signed in as (Sign out)

We’ll send you updates on this idea

Thank you for voting for “freeze pane for bottom row(s) of a range.” While this is a cool idea, we are not able to work on this soon.

We’ll keep tracking the votes on this.

14. ## Do not chart null values

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

Signed in as (Sign out)

We’ll send you updates on this idea

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.

Signed in as (Sign out)

We’ll send you updates on this idea

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

Signed in as (Sign out)

We’ll send you updates on this idea

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. We’ll keep tracking the votes, though.

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

Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the suggestion. We do think making the Find result more visible is a good idea, but we won’t be able to address it in the near future. We’ll keep tracking the votes on this.
-Sharon

18. ## Fiscal Year

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