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. Pick color in Excel Like at Powerpoint

    In Powerpoint there is a color picker tool to bring custom colors to the pallete.

    Many times we need to do it using PowerPoint to get the RGB combination to be used in Excel.

    Could you replicate this color picker into Excel in the same way it exists in PowerPoint?

    Portuguese:

    Conta-gotas PowerPoint

    No Powerpoint existe uma ferramenta para pegar as cores e retornar para a paleta, o conta-gotas.

    Vocês podem fazer o mesmo no Excel?

    Porque muitas vezes nós precisamos fazer isso usando o PowerPoint para pegar o RGB e colocar no Excel.

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

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

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

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

    Thanks for supporting this feature. We won’t be able to offer this 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. Old versions of Excel will not support the new behavior, so there would need to be some hybrid approach that will be suitable for old and new versions. Also, named ranges can be dynamic, meaning that the range might change and conditional formatting rules would have to be adjusted when the workbook is calculated. There are lots of cases to consider and deal with properly.

    We’ll continue tracking votes for this suggestion.

  3. Add Center Across Selection to the Merge & Center Drop-down

    Do you hate Merged Cells? Do you believe Merged Cells are evil? Do you curse every time your selection rectangle goes from one column to five columns just because you touched a merged cell? Do you constantly get workbooks from co-workers who continue to merge cells? Tired of not being able to Sort or Paste because someone merged a cell?

    Excel encourages people to use Merge & Center by offering it front-and-center on the Home tab. Thus, few people discover the (superior) Center Across Selection option on the Alignment tab of the Format Cells dialog.

    Currently, the Merge & Center…

    919 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

    107 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Number format thousand separator and no decimals

    Every time (many days a year) I train people in Excel, someone ask why there is no button or shortcut to obtain a number format with "thousand separator and no decimals". At least - in northern Europe - this is the most common used number format. If "button-solution" not possible for Microsoft in order to have common buttons world-wide, at least a shortcut for this has been much appreciated. (Note that the current button for thousand separator and two decimals could not be used, though the alignment in that format are not disired/good and two decimals used).
    Today I teach…

    622 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

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

    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…

  5. Improve the Conditional Formatting Manager

    So that we can easily manage conditional formatting. While we're at it, the way conditional formatting is treated when cutting / copying and pasting etc could be reconsidered.

    [Following examples added by the Excel team for clarity]
    * name rules
    * add a comment to rules
    * more easily see what rules apply to what range
    * see which rules can be consolidated b/c they are similar
    * have an option to LOCK THE RANGES so they never change no matter what cells in the sheet get moved or copied or deleted, either manually or by adjusting pivot tables
    *…

    532 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

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

    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]

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

    Offer a format that displays the boolean value of a cell as a checked box if TRUE, unchecked box if FALSE, grayed box if text or other nonbool.

    Bonus: Toggle value OnClick would be intuitive.

    Lots of uses for this. Current options are awkward for users. Yes/No dropdown is not as good as a checkbox for touch/mobile.

    255 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

    37 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Increase the Data Validation List Items Font Size

    The font size of the list items within a Data Validation list is often too small to read. If you can't add a feature to allow the user to choose the font size of the list, then perhaps you could do one of the following:

    1) Set the font type (Arial, Calibri, etc.) and size equal to the size of the Normal font

    2) Set the font type and size equal to the font size of the Cell

    See the related post in the Excel answers forum:
    https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msowinother/data-velidation-drop-list/fa0aa7f7-64fc-4856-ae76-e299480827db

    120 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

    17 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add an easy way (Ribbon button) to change text casing (UPPER, lower, Sentence, etc.)

    Currently Excel is the only Office application that doesn't have the ribbon-button to change selected text to uppercase or lowercase.
    The only way to do it is to use the function =UPPER() and then copy/paste the resulted value into the original cell.
    It would be good to have a button to change the selected text to uppercase or lowercase.

    111 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

    49 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. WE NEED! Dynamic Data Exchange (DDE) in combination with the Step-by-Step Mail Merge Wizard in Word

    WE NEED! Dynamic Data Exchange (DDE) in combination with the Step-by-Step Mail Merge Wizard in Word. Formatting columns as text to make this work correctly (ie, Zip + 4) is ridiculous!

    81 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

    63 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Please fix conditional formatting!!

    I create Conditional Formatting on whole columns. I should be able to insert, delete, blank within my range without Conditional Formatting breaking up into formatted sections which eventually causes some rows not to format correctly. I am constantly correcting the Conditional Formatting which is very time-consuming! It is such a handy tool but very frustrating tool to work with.

    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

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. Enable Feature to Autofit Row hight for Merged Cells (and not just single cells)

    Enable Feature to Autofit Row hight for Merged Cells (and not just single cells)

    65 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

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

    64 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 →
  13. Allow custom icon sets for conditional formatting

    At the moment, the build-in icon sets can't be modified. One common problem is the need for a green down arrow / red up arrow.

    61 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add number format for thousandth (K$) or millions (M$)

    Could you please add the number format K for thousandth and M for millions (like 5.8 K instead of 5812)
    It would be very helpful.
    Thanks

    55 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

    10 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Enable Center Across Selection to be added to the Quick Access Toolbar

    Everyone knows merged cells are evil and should only be used as a last resort.
    Center Across Selection is far superior, but you can't add it to the Quick Access Toolbar.
    Please add Center Across Selection to the list of actions that can be added to the Quick Access Toolbar.

    53 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

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Excel hex color codes for formatting

    Please allow to enter Hex color codes when choosing colors for cell fills, borders, fonts, charts, etc...
    RGB and HSV are triple the work!

    52 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 →
  17. 47 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. Dynamic headers/footers

    Add functionality to allow users to create dynamic/formula-driven headers and footers.

    39 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

    10 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. Enable transparent as a color option with Pattern fill.

    “Solid fill” offers transparency; “Gradient fill” offers transparency; “Picture or texture fill” offers transparency; yet “Pattern fill” does not. It is the sole fill means lacking this “color” offering (See attached.).

    Transparency as a color option would allow some interesting visualizations, especially when graphing on a secondary axis. Transparent for Background Color has the most obvious use, yet implementing as the foreground color should be provided as well to empower the user.

    Implementing this should be very straightforward.

    37 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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 →
← Previous 1 3 4 5 51 52
  • Don't see your idea?

Feedback and Knowledge Base