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. Make vertical alignment default to top of cell

    If any column has text wrapping applied, top of cell formatting makes data much easier to read, both on screen and printed version (especially if there are no borders)

    9 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 →
  2. Group/ungroup columns and/or rows in multiple sheets at the same time

    If we have multiple sheets that have the same amount of rows/columns and we need to group/ungroup certain rows/columns, we should be able to do this in one easy step. Currently we have to group/ungroup information on one sheet at a time and it's very time consuming.

    4 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 →
  3. Minimum Row Height

    I can currently set the row height to be automatic or set it to a fixed height. When working with tables which contain text, this often leads to a mishmash where rows are randomly one, two and sometimes three rows of text tall. This looks sloppy. I can manually review and set the row height for each row, but why should I have to.

    I should be able to set the row height to a minimum value. If the row needs to be taller to fully display a cell with wrapped text, then the row height should automagically increase. This…

    9 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 →
  4. Allow Decimal Indent Formatting and on Both Ends Simultaneously

    The current indent formatting uses only whole numbers. I use it often when cells contain a block of text because having the text hit both the left and right cell borders makes it harder to read.

    Unfortunately, I can only apply the indent to one edge of the cell (usually the left) and an indent of 1 is too big.

    In a better world, I would left indent the chunk of text and apply two decimal values to provide white space along the left and right edges of the cell. The result would look better and be easier to read.

    3 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 →
  5. Change Default Auto Fill Option

    Currently Double Clicking the bottom right corner of a cell will Auto Fill down to the last populated row in a data sheet. However in doing so it defaults to 'Fill Series' e.g. 1,2,3,4... it would be great to set the default to, say, 'Copy Cells' e.g. 1,1,1,1...

    10 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. Vertical text in the footer/header as in Word

    Make it possible to add vertical text on the page margin in the footer/header. For example, to have the path and file name standing along the edge of the paper while printing.

    2 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 →
  7. Conditional formatting check box on/off

    Conditional formatting check box on/off
    Make it is possible to have multiple Conditional formatting in a list in an Excel book and turn on and off them (with checkboxes) to choose which shall be active or not. Much like Outlook rules that can be active or not.

    6 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. Right click for conditional formatting

    Please add the conditional formatting menu to the options available when you right click a cell.

    11 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 →
  9. Drop Down List

    How about making the drop down list show more than 10 items at a time without having to scroll? Many years ago when using Excel for Mac, the drop down list would run the length of the screen. Not sure if this was a feature specific to Mac, but it would make using drop down lists a lot more useful on a PC.

    17 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 →
  10. Lock or protect formatting

    It would be good to be able to lock or protect the formatting of cells (including columns, rows and ranges) so that the format is preserved by default when data is pasted in.
    Also, this could be used to prevent Styles from overriding customised formatting of sheets and charts.
    This doesn't have to be password protected - just a safeguard against accidental changes.

    17 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. Currency format scroll menu (or any scroll menus): a better way to find the one you need

    Searching for currencies in the format menu is a pain, probably because of the sheer amount of options.

    For example, try finding "R$ Portuguese (Brazil)" on that menu. It's really small, so I can only look a small number of entries at a given time. I mean, I generally remember vaguely the name of the format. For instance, with Brazilian Reais I know that there's an R and a $ at the beginning, and also that Brazil and Portuguese appear somewhere in the name. However, if I type R the menu goes to "ROL", and if I type $ it…

    6 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 →
  12. 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 →
  13. 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 →
  14. Microsoft keyboard shortcuts for in-cell alignment.

    Other Microsoft products allow keyboard shortcuts to align text. Please add these to Excel: Ctrl-E to center a cell's contents, Ctrl-R for right alignment, Ctrl-L for left alignment.

    4 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. Support formatting or rounding to user-specified number of significant figures

    I work in a research organization and it's common for us to need to display values to a pre-specified number of significant figures. If you search the internet for "Excel significant figures" you will see a variety of hacks which work to varying degrees. It would be great to have built in support to display to a user-specified number of sig figs. E.g. 1234, displayed to 2 sigfigs, is 1200. Alternately, a built in function which rounds to a specified number of sigfigs would also get the job done.

    20 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 →
  16. 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,020 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

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

  17. Preserve text colour when using Find/Replace

    Currently using Find/Replace on a cell containing more than one text colour results in all the text becoming the same colour. This is not a desirable default.

    3 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 →
  18. Add Conditional Formatting for enumerated values

    When a Column or Row contains enumerated string values like ("Large", "Small", "Medium"), or ("Bob", "John", "Anna") it would be useful to automatically assign a color based on the cell contents.
    Currently, this requires to add one rule for every possible value of the type 'equals to "..."'.
    It suggest to add a Conditional Formatting rule that assigns a unique color per unique value (based on some color set)

    2 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 →
  19. Prior year assumption in December dates entered in January

    Many people enter recent dates into excel to balance bank accounts etc and Excel always assumes the year in dates entered as the current year. This makes everyone not need to type out the year except for about half a month every year.

    9 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 →
  20. Add a hotkey for the format painter

    For something that is used so much, I can't understand why there isn't a hotkey for it yet.
    Yes I could make my own with a customisable ribbon, but I would really like to not have to do that every time I sit at a new computer

    5 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 →
  • Don't see your idea?

Feedback and Knowledge Base