My feedback

1. Put the color back in the Quick Access icons. The 2016 icon are impossible to decipher.

   • 

   • 

   227 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

   168 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   An error occurred while saving the comment
   David Benaim commented  ·  Dec 19, 2018  ·  Edit…  ·  Delete…

   Hey! I had this issue too, then I realised that if you choose to show the toolbar below the ribbon and you get all the colours back!

   Save Submitting...

2. 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
   David Benaim commented  ·  Dec 19, 2018  ·  Edit…  ·  Delete…

   OMG yes!!! I also have a Macro that I use daily and Im also an Excel trainer so; explain how it isn't available. This should be the default!!!! Plus number formats with k or M is also lacking, PowerBI does it automatically

   Save Submitting...
   David Benaim supported this idea  ·  Dec 19, 2018

3. Format cell as a checkbox (TRUE, FALSE)

   243 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

   37 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 the idea! We think formatting cells as a checkbox is an interesting suggestion, but we won’t be able to address it in the near future. We’ll continue tracking votes for it.

   An error occurred while saving the comment
   David Benaim commented  ·  Dec 6, 2018  ·  Edit…  ·  Delete…

   Yess this would be lovely! Better than yes/ no drop down

   Save Submitting...
   David Benaim supported this idea  ·  Dec 6, 2018

4. Use a contrasting colour to indicate hidden rows/columns

   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) » Graphics  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   David Benaim supported this idea  ·  Nov 30, 2018

5. Create a function that returns the list of sheet name(s) in the workbook = SHEETNAME(), =SHEETNAMES()

   136 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

   18 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   David Benaim supported this idea  ·  Oct 20, 2018

6. Two new =if's

   240 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

   13 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

   Thanks for the suggestion figboot. As always, we’ll prioritize this according to the number of votes it gets, so please be sure to vote it up if you want to see it done sooner.

   Thanks
   John [MS XL]

   David Benaim supported this idea  ·  Oct 20, 2018

7. Improve Data Validation (make it AutoComplete based on typed characters)

   287 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

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

   Hi all – thanks for your support for this suggestion.

   Improving data validation drop down lists by adding autocomplete is a great idea, as well as supporting structured table references in the data validation Source range.

   Steve – Microsoft Excel

   An error occurred while saving the comment
   David Benaim commented  ·  Oct 20, 2018  ·  Edit…  ·  Delete…

   Yes! Google sheets does this and it’s game changing!

   Save Submitting...
   David Benaim supported this idea  ·  Oct 20, 2018

8. Make Undo stacks track per workbook instead of globally

   1,130 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

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

   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 same rows of column B. You change the formula by switching last parameter from “Yes” to “No”. Then you insert a row in workbook B which causes the references in workbook A to adjust accordingly to refer to rows 2-11 rather than 1-10. The formula would be =SUMIFS. If you then undo the formula change in workbook A, the references would again refer to rows 1-10, which would give an unwanted result, since it would not take into account that you inserted the row.

   Step-by-step, the formula would be as below:
   =SUMIFS

   Change “Yes” to “No”:
   =SUMIFS

   Insert row 1 in WorkbookB, and Excel adjusts the range reference accordingly:
   =SUMIFS

   Undo in WorkbookA – the range references would then be incorrect, because the inserted row would still exist in WorkbookB:
   =SUMIFS

   You would expect the formula to keep the references and only change “No” back to “Yes”, like this:
   =SUMIFS

   There are a number of other challenges and tradeoffs to consider between the current behavior and the requested behavior. We wanted to let you know it would be significant undertaking to make this change. Your votes and suggestions help us plan and prioritize, and we sincerely appreciate all the interest. Even though we don’t have plans to address this soon, we’ll continue to monitor the votes.

   Thanks,
   Steve K [Microsoft Excel]

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

   David Benaim supported this idea  ·  Oct 20, 2018

9. Improve the Conditional Formatting Manager

   516 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

   101 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 your support of this suggestion and all the great ideas in the comments. We have at least one improvement planned (resizing the dialogs – see link in the description), and we’re looking at some additional improvements.

   If you have specific ideas that aren’t already listed, please add them in a comment.

   Steve [Microsoft Excel]

   David Benaim supported this idea  ·  May 23, 2018

10. Make it easier to find external links

    357 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

    33 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

    Thanks for your feedback! We’re reviewing your suggestion. Remember, the more votes a suggestion gets, the more likely it is that we’ll do it.

    David Benaim supported this idea  ·  May 23, 2018

11. Support multi-row worksheet tabs, or vertical tabs, or font size (some way to see more sheet tabs at a time)

    •  

    652 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

    139 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    not at this time  ·  Eric Patterson (Program Mgr - MSFT) responded

    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.

    David Benaim supported this idea  ·  May 23, 2018

12. VLOOKUP function for multiple criteria

    389 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

    15 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

    Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

    Best,
    John [MS XL]

    David Benaim supported this idea  ·  May 23, 2018

13. Add 'date picker' to enable users to select a date from a mini calendar into cells

    2,281 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

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

    Hi all,

    We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

    Thanks!
    Blake, Excel Product Team

    David Benaim supported this idea  ·  May 23, 2018