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…

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

    We’ll send you updates on this idea

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

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

  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…

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

    We’ll send you updates on this idea

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

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

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

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

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

    59 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 →
  10. 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)

    59 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 →
  11. 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.

    58 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 →
  12. 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

    48 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 →
  13. 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!

    47 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 →
  14. 44 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 →
  15. 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.

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Dynamic headers/footers

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

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

    We’ll send you updates on this idea

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

    31 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 →
  18. Reference Cells to Test Other Than the Cells Being Formatted in Conditional Formatting Rules

    With the "Use formula..." rule, we can simulate all but one of the other rules while referencing cells other than the ones being formatted. But we can't simulate the effects (gradient color) of the "Format all cells based on their value" rule. By adding an additional (optional) cell reference to all rules except the "Use formula..." rule, we can more easily set up rules (and effects) across rows in tables as well as color status cells that contain text but which we want to add the additional affect of a gradient color. At a minimum, add the option just to…

    28 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 →
  19. Add ability to change border color of all existing borders in a selection

    I have formatted my spreadsheet with some cells having thick line borders, some having thin line, dotted lines, etc. I now want to change the color of ALL borders in a selection. I would like to be able to select an area, then choose "change border color" and select a color from the selector. All existing borders would then be changed to that color.

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

    We’ll send you updates on this idea

    8 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Improve merging of conditional formatting

    When cells are moved within a conditionally formatted range, the rules are duplicated for the destination cells making management of the conditional formats more difficult.

    To illustrate the problem, run this macro which conditionally formats a range of cells, copies column C and inserts before column G. Then Home > Conditional Formatting > Manage Rules > for This Worksheet. The rule has been duplicated for the new column F rather than being merged with the original rule which now applies to a 2-area range. This makes changing the rule for the entire range subsequently more difficult and error prone.

    Sub…

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

    We’ll send you updates on this idea

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

Feedback and Knowledge Base