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

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

    We’ll send you updates on this idea

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

  2. 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…

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    62 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  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 Dan [MS] for clarity on 10/20/2015]
    * 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
    * etc.

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

    We’ll send you updates on this idea

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

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

  6. Modernize conditional formatting formula editing.

    As of 2013, it conditional formatting formula editing is still inconsistent with the regular application, and makes it harder for users to learn conditional formatting, which is one of the more abstract concepts of the early Excel learning process.

    Arrow keys are still modifying formulas rather than moving the cursor, for example.

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

    We’ll send you updates on this idea

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

    Great suggestion, thanks David! And thanks to other people who took the time to clarify/comment on this one. There’s definitely room to tighten this experience up in a number of places. We’re getting a lot of traffic on the site, so please keep voting for the things you care about most to help us do a great job of prioritizing.

    Best,
    John [MS XL]

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

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

    We’ll send you updates on this idea

    33 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. The Conditional Formatting Rules Manager badly needs the ability to be resized

    The Conditional Formatting Rules Manager dialog box is far too small for modern display resolutions. It really should be a resizeable dialog, and should include the ability to resize column widths, so that the full length of complex conditional formatting expressions can be displayed and read without having to open them for editing.

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

    48 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. 45 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add A Color Picker Tool

    A simple color picker tool has been something I have been forever longing for! It would be so nice to have the ability to grab colors from an image on the fly instead of having to use a third-party tool and manually type in the RGB code.

    I envision this being an Office Suite feature, where you could grab colors from say a PowerPoint slide or even a web page and fill your selected cells with the exact color.

    If you wanted to get really fancy, you could even have a column in the pre-formatted Ribbon galleries to update one-click…

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Dynamic headers/footers

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

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

    We’ll send you updates on this idea

    10 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 42 43
  • Don't see your idea?

Feedback and Knowledge Base