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

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

    10 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 →
  3. 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.

    12 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 →
  4. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

    26 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 →
  8. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    18 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 →
  10. 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…

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

    We’ll send you updates on this idea

    235 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)

  11. 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
    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 →
  12. 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
    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 →
  13. 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.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    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 →
  15. 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
    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 →
  16. 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

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

    We’ll send you updates on this idea

    12 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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 →
  19. 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.

    224 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]

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

    365 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]

  • Don't see your idea?

Feedback and Knowledge Base