My feedback

1. Display pivot table headers in the columns headers

   •  

   58 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   We’d like to see how many votes this gets as a way to help us prioritize the work. Thanks!

   Anonymous supported this idea  ·  Jul 11, 2020

2. "Worksheet Sorter" for Excel

   98 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   10 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Anonymous supported this idea  ·  Jul 11, 2020

3. Pick color in Excel Like at Powerpoint

   •  

   1,142 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   109 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thanks for this suggestion. If you’d like to see the eye-dropper tool to pick a color in Excel like you can in PowerPoint, please vote for this idea.

   Steve [Microsoft Excel]

   Anonymous supported this idea  ·  Jul 11, 2020

4. Make all windows (Dialog Boxes) containing variable-sized content resizable

   •  

   •  

   165 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   42 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   This is a great suggestion, but we’re marking it “Not at this time”, because there are many dialogs in Excel and we don’t have a plan to address all of them at one time. If there are specific dialogs you want improved, please vote for specific suggestions about those, or leave comments here. We’ll keep tracking the votes on this one.

   There is some good news. We’re working on making the Conditional Formatting dialogs resizable in Excel for Windows.

   Here’s more about that –
   https://excel.uservoice.com/forums/304921/suggestions/16092793

   Steve [Microsoft Excel]

   An error occurred while saving the comment
   Anonymous commented  ·  Jun 11, 2020  ·  Edit…  ·  Delete…

   I support this idea of resizable dialogue box

   Save Submitting...

5. Use F4 key to lock reference in a table

   176 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   17 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

   Best,
   John [MS XL]

   Anonymous supported this idea  ·  Jun 11, 2020

6. Watermark

   59 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   22 comments  ·  Excel for Windows (Desktop Application) » Printing  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   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

   An error occurred while saving the comment
   Anonymous commented  ·  Apr 9, 2019  ·  Edit…  ·  Delete…

   Idea of insertion/ removal of Watermark in the excel sheet like in word is likely for some creative work

   Save Submitting...
   Anonymous supported this idea  ·  Apr 9, 2019

7. Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

   1,308 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   966 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

   Some of the specific issues mentioned are addressed as follows:
   – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
   - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
   - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook.
   – Links: The behavior of linked workbooks should not be affected by whether the workbooks appear in a single window or multiple windows. If you need to open a separate instance of Excel to avoid updating links, you can still do so by holding ALT when you click the shortcut to start Excel, or by running the command “Excel.exe /x”.
   – Closing workbooks: To close all documents and exit Excel, you can either right-click the Excel icon in the task bar and choose “Close all windows”, or you can add the “Exit” command to the quick access toolbar. Then use this button to close all your workbooks with a single click.

   For other issues, it would be great to deal with those specifically, either by submitting a separate suggestion here on UserVoice, or by sending feedback within Excel. For example, if there are specific issues with VBA, whether they’re related to SDI or not, please submit that feedback.

   If you’d like to find out about the Excel team priorities, please read this post on our TechCommunity – https://techcommunity.microsoft.com/t5/excel-blog/excel-product-team-fy20-goals/ba-p/1342022.

   Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

   Some of the specific issues mentioned are addressed as follows:
   – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
   - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
   - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. … more

   An error occurred while saving the comment
   Anonymous commented  ·  Apr 9, 2019  ·  Edit…  ·  Delete…

   Bring back MDI in excel sheel will be good idea in future

   Save Submitting...
   An error occurred while saving the comment
   Anonymous commented  ·  Apr 9, 2019  ·  Edit…  ·  Delete…

   In terms of stability the Excel sheet require more work for the stability as it usually hangs on working with multiple sheets or on working with older version of excel sheets

   Save Submitting...
   Anonymous supported this idea  ·  Mar 15, 2019

8. Number format thousand separator and no decimals

   616 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   109 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thanks for all the support and comments about this request. We don’t have plans to add this format in the near future, but we’ll keep monitoring the votes as we prioritize this suggestion among other requests.

   There are a few ways that you can enable this already, as mentioned in some of the comments.

   1. Set the style used when you click the comma button.
   – This can be done by modifying the cell style called “Comma”, which is used when you click the comma button. See the screen shot in the comments for details, or look at this article to modify the style – https://support.microsoft.com/office/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22.
   – For existing workbooks, you’d need to set the style in each workbook.
   – To make it the default in new workbooks, you can create a new workbook, make the change to the “Comma” style, and then save the workbook as a template to be used for new workbooks. Follow the steps here: https://support.microsoft.com/office/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19

   2. Another option is to create a macro in your personal macro workbook which can be assigned to a shortcut key or added as a button to your QAT or ribbon. To do so, select a cell containing a number, then start recording a macro. Type a name for your macro, and type a letter to use as the shortcut key you want, such as T (the shortcut would be CTRL+SHIFT+T). Make sure you choose to store the macro in your Personal Macro Workbook, so it’s available no matter which file you have open. Then click OK to start recording. Then set the cell format as desired and stop recording.

   With that, can select a range of cells and press CTRL+SHIFT+T to apply the number format.
   The macro should have code that looks something like this:

   Sub SetThousandsWithNoDecimals()

   ’ Set Thousands With No Decimals
   ’ Keyboard Shortcut: Ctrl+Shift+t
   ’
   Selection.NumberFormat = “#,##0_);(#,##0)”

   End Sub

   Steve [Microsoft Excel]

   Thanks for all the support and comments about this request. We don’t have plans to add this format in the near future, but we’ll keep monitoring the votes as we prioritize this suggestion among other requests.

   There are a few ways that you can enable this already, as mentioned in some of the comments.

   1. Set the style used when you click the comma button.
   – This can be done by modifying the cell style called “Comma”, which is used when you click the comma button. See the screen shot in the comments for details, or look at this article to modify the style – https://support.microsoft.com/office/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22.
   – For existing workbooks, you’d need to set the style in each workbook.
   – To make it the default in new workbooks, you can create a new workbook, make the change to the “Comma” style, and then save the workbook as a template… more

   An error occurred while saving the comment
   Anonymous commented  ·  Apr 2, 2019  ·  Edit…  ·  Delete…

   yea this a common problem of number format a shortcut is required in excel workbook

   Save Submitting...
   Anonymous supported this idea  ·  Mar 15, 2019

9. Here's an idea to insert watermark on the sheet and to remove watermark also

   7 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   3 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Anonymous shared this idea  ·  Mar 15, 2019

10. Unhide multiple worksheets at once

    772 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    70 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    We are excited to share an update on the feature availability. This is available on Excel Insiders min build: 16.0.13525.10000, and on Mac Insiders min build:16.44.1125.0. We will post updates here as this rolls out to Current Channel. (A description of Office channels can be found here: https://docs.microsoft.com/en-us/deployoffice/overview-update-channels )

    If you are excited by this change or have comments for us, please share at File→Feedback.

    Thanks, Urmi

    Anonymous supported this idea  ·  Mar 15, 2019

11. Let me choose Decimal separator and Date order in PowerQuery instead of guessing

    33 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Anonymous supported this idea  ·  Mar 15, 2019

12. Function and formulas recommended

    •  

    76 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    21 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Anonymous supported this idea  ·  Mar 15, 2019

13. Tables should default to "My table has headers" being ticked

    •  

    145 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    12 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Anonymous supported this idea  ·  Mar 15, 2019