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. 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 →
  2. 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 →
  3. 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 →
  4. 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…

    25 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 →
  5. 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)

    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

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

  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. enable the user to dorce particular cells to use a particular data-type (not format)

    Will you ever have a way to safely preserve numbers with leading zeros, like phone-numbers?

    Currently if stored as a number, the leading zero will be lost. Storing them as text is not a perfect solution, as the software indicates that they are numbers stored as text, and in some operations the data-type is converted to a number, losing the leading zero again. This can be a real pain with long lists of phone numbers or reference numbers.

    It would be great to be able to force particular cells to use a particular data-type at all times (not just the…

    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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Engineering Notation

    In engineering, it is very common to use scientific notation that only displays numbers in factors of 10e-6, 10e-3, 10e0, 10e3, 10e6, 10e9, etc. I've seen this called "engineering notation" - it's just a special subset of scientific notation.

    It would be great to have an extra formatting option for this.

    For example:
    1.3e5 would be displayed as 130.0e3
    2.0e6 would be displayed as 2.0e6 (no change)
    3.2e10 would be displayed as 32.0e9

    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

    13 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add support for Epoch time in Date & Time cell formatting options

    I frequently work with data where date and time are represented in the Epoch time-stamp format, or where it is preferable to use this format for scripting purposes. Please add support for Epoch time-stamps so that intermediate processing of time-stamps is not required when importing the data to excel.

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

    62 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 →
  17. 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]

  18. 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 →
1 2 48 49 50 52 Next →
  • Don't see your idea?

Feedback and Knowledge Base