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. Break link from source data to pivot table

    At present you cannot send the output of a pivot table without the link to the underlying data - but often I want to do exactly that - share the results without sharing the base data.
    Cutting and pasting the pivot table works but loses all the careful formatting (actually worked much better up to Excel 2010, now entirely broken).
    So please can we have a method of preserving the output from pivot tables but delinking them from the source?

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

    We’ll send you updates on this idea

    23 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    If we break the link to the data, the PivotTable will no longer be interactive and won’t support expand/collapse, filtering, or sorting. Copy/Paste into Paint or any other graphics program will preserve an exact picture of the PivotTable with all formatting. In any event, this item isn’t likely to be addressed soon.

  2. PowerPivot Calculated Tables

    Please bring Calculated Table feature from Power BI into the Excel Data Model. It is very useful to create intermediary tables from DAX calculations and link those tables into the data model.

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

    We’ll send you updates on this idea

    3 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    We agree that this feature would be useful for many users. The difficulty is that adding this feature would break compatibility for existing Excel users, Data models with this feature would not run in Excel 2013, 2016, or 2019. At this time, we consider compatibility to be more important than this particular feature. At some point in the future we expect to find a way to deal with this compatibility issue, but we won’t be able to address this anytime soon.

  3. Make Undo stacks track per workbook instead of globally

    Undo stacks are currently global between all workbooks that are open at a given time, so pressing undo on one workbook might undo a change in a different workbook. As someone who frequently has multiple workbooks open at a time, it would be much more helpful to be able to step through the edits made on each individual workbook.

    1,125 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    226 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

  4. Fill Handle For Worksheet Copy

    If I have a worksheet called January and I Ctrl+Drag that sheet to make a copy, Excel should automatically call it February. Use the same logic as the Fill Handle (support months, weekdays, and any custom list).

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

    We’ll send you updates on this idea

    12 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking your time to suggest and vote for the “fill handle for worksheet copy”. While this is a good suggestion, we are not likely to be able to devote time to it in the near future. We’ll continue tracking the votes for this, though.

  5. Conditional formatting - Apply to named ranges

    Currently if you apply conditional formatting to a named range (i.e.. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Condidtional Formatting Rules Manger will revert the named range to its absolute cell reference.

    eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".

    Apart from being more difficult to read, it creates other complexities. e.g. if I happen to copy/paste a cell into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.

    e.g. if my named range is 'Table1[Column3]' which…

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

    We’ll send you updates on this idea

    259 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for supporting this feature. We won’t be able to in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

  6. Display Status Bar of Inactive Window 2016 Excel

    In Excel 2010 we were able to highlight numbers and have their sums displayed in the grey status bar towards the bottom of the sheet. Working with 2 monitors, this feature was very helpful.

    After upgrading to Excel 2016 the status bar of the non active/selected workbook disappears instead of the sum being viewable of the non active workbook.

    The feature was helpful for at least 2 open excel instances where we can view the sum of the non active workbook and it would be great to have back instead of being forced to click in out of each workbook…

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

    We’ll send you updates on this idea

    33 comments  ·  Viewing / Navigating Workbooks  ·  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.

    38 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. Link the min and max values of a chart axis to cell value

    It would be nice to be able to link the min and/or max value of an chart axis to a cell reference instead of manual enter the value or the auto function.

    1,203 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion 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, and please keep sharing your thoughts!
    Auston [MSFT]

  9. 521 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for taking your time to suggest and vote for this. 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 so we know how it ranks among the other suggestions.

  10. Allow users to control the order of items in the sunburst chart.

    I'm using a sunburst chart to convey status, and visually it would be nice to have the chart in the same order as the items I want to talk about them, so the discussion flows clockwise around the wheel. Having an option for the layout to follow the order in the excel list would be wonderful

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

    We’ll send you updates on this idea

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

    Thank you for taking the time to share your request for controlling the order of items in sunburst charts!

    We think this suggestion 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]

  11. Give us a proper NULL() worksheet function.

    This would make calculations and charts treat a cell containing a formula as a blank cell, not as a cell with a text string ("") or as a zero.

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

    We’ll send you updates on this idea

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

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    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.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

  12. Embed 3D maps in worksheets

    Add the ability to embed 3D maps within an excel sheet. If you are making an excel-based dashboard, it would be great to have the capability to showcase the map right within the sheet instead of as a pop-out visual.

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

    We’ll send you updates on this idea

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

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

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

  13. Excel Pivot Tables Auto Time Grouping by Week

    In Excel 2016 you can only group by day, month, quarter or year. Please add the ability to group by weeks or re-add the capability to group by number of days for pivot table data.

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

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    The best way to accomplish this is to add a column to your data that specifies the week. By using a custom formula, you can organize the weeks any way you want, with any starting day of the week, and also name them any way you want, whether “Week of July 10” or “Week 34” or something else. Then you can use that column in a PivotTable to see data grouped by week.

  14. Remember the chart type, chart formatting (and template) on Pivot Charts

    When you're charting a pivot table and have a combo chart - say stacked bar chart with a line chart - and you filter your pivot table so that one of the stacked bar elements disappears, the chart replaces the missing element from the line chart. Remove the filter and your line chart is still part of the stacked bar chart.

    I'd like the pivot chart elements to remain in their place even when there's nothing to show because of the filter.

    Additionally, any formatting applied via Chart Templates to Pivot Charts is lost on Pivoting, etc. - this formatting…

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

    We’ll send you updates on this idea

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

    Thank you for taking the time to share your request for remembering chart type/formatting for Pivot Charts!

    We think this suggestion 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]

  15. Rotate sunburst chart (& other controls)

    LOVE THE NEW SUNBURST. Great work, guys - please keep it up. Would like ability to rotate the sunburst chart (just like we can with the regular pie chart) and have much more control over the final product, such as: ability to turn visibility on or off for any segment (sometimes really important segments are not labelled because they are relatively small - please give us control), more control over colors of segments and sub-segments, better font size & text rotation of labels, more data label options such as pop-out / data callout and other options found on pie chart.

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

    We’ll send you updates on this idea

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

    Thank you for sharing your request around sunburst chart controls! While we think this suggestion has merit; 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, and please keep sharing your suggestions!
    Auston [MSFT]

  16. Conditional formatting in charts

    Add Conditional formatting in charts to control the colour of e.g. a bar or line, depending on the value or content of the data labels. Green if appels, Yellow if bananas and so on.

    157 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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 request for adding conditional formatting in charts!

    While we think this suggestion has merit, we don’t expect to devote time to it in the near future. 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]

  17. 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 →
  18. 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

    95 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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]

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

    99 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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]

  20. Watermark

    Add a Watermark Tool with the same functionality as MS Word

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

    We’ll send you updates on this idea

    22 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base