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. "Dax Formatter" Nativo no Power Pivot (Excel & Power BI)

    Um sugestão seria ter um botão na "Caixa de Diálogo"
    Medidas no Power Pivot (Excel) para "identar" as funções DAX digitadas, como mostra o anexo.

    34 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

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

    33 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

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

    31 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

    8 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Dynamic Arrays, Spill range format

    When a Spill range changes (eg due to the source data changing) it would be nice if any Formatting that is applied to the Spill Formula Cell is also applied to the entire Spill Range.

    30 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 →
  5. 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…

    30 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

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Bytes-KB-MB-GB-TB

    Please add the ability to format cells by computer file sizes - i.e:
    Bytes
    Kilobytes (bytes * 1024)
    Megabytes (bytes x 1024 x 1024)
    Gigabytes (bytes x 1024 x 1024 x 1024)
    Terabytes (bytes x 1024 x 1024 x 1024 x 1024)

    29 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

    7 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Named conditional formatting rules

    Named conditional formatting rules - If you could name your rules they would be easier to identify. Also, it would be nice if you could right click a cell and have a choice to add it to a named conditional formatting rule. Excel would need to be intelligent enough to be able to add the cell or group of cells to the rule correctly.

    26 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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. Is it possible to have red arrow goes up and green arrow goes down for conditional formatting ?

    In the options of the conditional formatting, you can select arrows. The red arrow goes down and the green arrow goes up. Is it possible to have the color in the other way round red goes up and green goes down ?

    24 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

    6 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. "Clear all" feature should be clearer to spot (and have shortcut)

    I teach excel, and it feels like around 90% of students (daily Excel users) don't know the clear all function exists. Also when someone press the delete key, 90% of the time, they mean to press clear all, they just don't know it exists, so they then remove the fill, change the colour, delete borders, unmerge cells etc, These all take many clicks.

    I truly believe that MOST Excel users waste time every day because they don't know of the existence of "Clear all". Excel should make this really obvious by 1. Adding a keyboard shortcut (Shift + Delete maybe?)…

    24 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 →
  10. Paste conditional formating as static formating

    In the same way you can paste values of a sheet with a lots of formulas I would love to paste formating achieved with conditional formatting. On big spreadsheets, conditional formatting can render the workbook unusable, but it's actually quite convenient to define formatting with conditional formatting. I normally paste formating from a hidden row to set anything I need, but I would love a way to leave the sheet to be fast. Am I explaining myself clearly? Having a conditional format set a cell to red, after "pasting conditional formats to static formats" the actual color of the cell…

    24 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

    6 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. Custom Format for Brazilian months in capital

    Allow mmm or mmmm custom formats to capitalize first or other letters of the months by using
    Mmm / Mmmm instead or even
    MMM / MMMM

    Specially for portuguese/Brazil. By using custom format, we always have month in lower case.
    We all want to be able to custom format the date and see:
    Jan/2018
    Fev/2019
    Abr/2020
    Out/1979

    But in portuguese, only portuguese, this never happens.

    23 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

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. drop down list (data validation) scrolling and searching

    When opening the list, allow search-as-you-type in the list to choose from.

    When the value is selected with single click, do not commit the change. Just close the list with the cell still in change mode. Let the user scroll up and down the values with keys or mouse-wheel and only commit after enter or another mouseclick.

    23 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 →
  13. Styles for conditional formatting

    The applicability of styles would be greatly enhanced if they could be included in conditional formatting.
    Example:if the value in this cell is zero or negative than it would automatically receive the Bad style, otherwise the Good style. (It is hard to see use for these two styles without them being applied by conditional formatting)

    23 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 →
  14. Let add setting to switch gridlines on/off

    Now we can do that for current worksheet only. These days it's quite desirable to have an option to keep greedlines off on permanent basis for each new workbook. That could be done using template or by changing/adding registry key https://www.quora.com/What-are-some-ways-of-removing-gridlines-in-Excel-2007.
    That will be much more suitable if we have such option in Advanced section of Options.

    22 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 →
  15. Improve Conditional Formatting

    This covers several areas I think need massive improvement in Conditional Formatting.

    The CF manager is terrible in general, but specifically
    1. there should be a way to nest CFs for compounding rules
    2. overlapping rule ranges should automatically merge themselves, as it is now, managing a CF which has gone through copy-paste (or Format Paints) several times are incredibly cumbersome to edit.
    3. the Editor itself needs an overhaul to make it more user-friendly and powerful, at minimum, make it so you can select multiple rules, and so the window is resizable.

    Rules themselves could use more options, be…

    22 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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Update AutoFit Row Height Feature To Work At Any Zoom Level

    Note: This request assumes there are NO merged cells in the worksheet. It also recognizes the maximum row height of 409.5.

    With "Wrap Text" enabled, the "AutoFit Row Height" feature is supposed to automatically increase or decrease the row height to ensure all text in a cell is visible. Unfortunately, the zoom level impacts whether or not the feature is successful. Sometimes, the text in a cell appears as expected: all visible with no extra white space above or below. Other times, “lines” of text are hidden from view. And other times, all of the text is visible, but “lines”…

    22 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. Page Setup - Header/Footer - combined feature requests

    This idea combines a host of ideas which all call for similar functionality. The individual postings score minimal votes but together they add to 75 votes. I raise this to combine the feature requests, so that it gets prominence as I would dearly like to see this addressed.

    Features for the Header / Footer:
    1. include variables based on a cell reference
    2. more than one Picture and Shapes
    3. Print and save dates
    4. Number of pages of the sheet and of the workbook
    5. Add file properties (quick parts in Word)
    6. Option for the header/footer on the…

    21 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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. Conditional formatting

    With respect to conditional formatting, that may I suggest that whenever one inserts a line that falls in between the range of ‘applies to’ in the conditional formatting, that the range would simply be adjusted instead of treating the inserted row as being separate in the ‘applies to’ range, and creating other ranges to denote ranges that exclude the inserted range. It’s much more complex editing conditional formatting rules.

    21 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 →
  19. Need the ability to format multiple colours of text in one cell for excel online

    Currently in Excel Online, when I format the colour of text in a single cell it changes the colour of all text in that cell. I would like the ability to change the colour of highlighted text only so I can have multiple colours of text in one cell.

    After looking on multiple forums, I can see this has been an issue for many users for a number of years.

    21 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 →
  20. Conditional Formating

    Conditional Formating
    Create an authomatic key or legend always visible, for the conditional formating rules aplied to a table, that improves the understanding of the results when lots of diferent formats are aplied. Allow to apply labels or tags to each format

    Improve the template manager, at least, make it bigger, because it's very uncomfortable to check what you have done, and to check where did you aplied the formats and its priority

    21 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

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base