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. Apply button for the Format Cells dialog box

    This would simply be the addition of an 'Apply' button in the format cells dialog box. This way formatting changes can be viewed without having to reopen the dialog box.

    1 vote
    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 →
  2. Find and replace text

    When i am find the text after replace, font styles are affected(changed) in the cell contents.
    Please any idea?
    Thanks.

    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 →
  3. Increase/decrease decimal should work regardless of the active cell

    If you have a mix of text and numbers selected, then increase/decrease decimal (in the Home tab) will not work if the active cell is text, but it will work and be applied to all numbers if the active cell is a number.

    This issue comes up when you have a column of all numbers except for the title at the top. Then when you select the whole column and try to increase/decrease decimal, it will fail until you activate a numerical cell.

    2 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 →
  4. Shortcuts for formatting

    Please make the shortcuts the same within Excel!
    Consistency is key :)
    If I want to make a part of a text in a cell superscript, I use Ctrl+Shift+P and the Alt+E to make it superscript. If I want to do the same in a text box (e.g. axis title) in a chart window, I also use Ctrl+Shift+P to get to the formatting, but now I need to press Alt+P to make it superscript.

    1 vote
    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 →
  5. Clear Formats does not clear formatting on characters

    It appears that Clear Formats only works on whole-cell formatting. Formatting on specific characters within the text of a cell is unaffected by Clear Formats, which is probably not what anyone wants.

    My suggestion is to either add another clear option where character formatting is not preserved or change Clear Formats to truly clear all formatting. Which one gets implemented depends on how important the preservation is.

    2 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. Change automatic border color

    Black borders are ugly and take attention away from the data in tables. I would like to be able to switch the default border color to gray, but I can’t do that either at the workbook or the sheet level. This means that I have to manually change the border color or paste formatting every time I add borders.

    I’ve tried setting preferences in the Workbook and Worksheet templates in the XLStart folder, but the border preference does not stick.

    This is not to be confused with the default gridline color, which can be set in the Advanced Excel option.

    2 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 →
  7. Formatting comments all at once

    Set the default format for ALL comments instead of going through Windows-->Tools. That doesn't work!!

    I have an old Excel spreadsheet and need to reformat all the Comments at once. That's only possible with a Macro, which for inexperienced users is a royal pain!! Why can't we just set the Comments without three layers of stupid menus and one at a time??!! Who's brain child was that??!!

    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 →
  8. pivot table formatting

    Using "grouping" of numerical data - there are no controls available for formatting the numerical ranges on the left side of the PT. I want to be able to add thousands separation (at a minimum). I would like to be able to change 0 -9999 to 0.0..k - 9.9..k, etc. Data should be pleasantly readable. Maybe some Displayed units similar to Axis formatting on charts.

    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 →
  9. Dot/coma problem on numeric keyboard if switch English to another language

    I use few languages in excel. (Mac office 2016/ MAC)
    All languages regional settings on mac are same: decimal=[.]
    But it works OK only for US language. When i switch to another language in excel and type numbers my numeric keyboard type [,] instead of [.]

    2 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 →
  10. 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 →
  11. 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 →
  12. Do we need 15 decimal places?

    Who needs 15 decimal places? The IEEE round off error were users get, say, 12.3 × E-15 when they expect zero just confuses then and undermines their confidence in Excel and in themselves.

    I cannot see any one in the finance world needing 15 decimal places.

    Few, if any, engineers/scientist work with that sort of precision. Look up physical constants and you will find they are generally known to only 9 significant figures: Planck constant h = 6.626 070 040(81) × 10−34, were (81) is the std dev in the last two decimal places. Albeit some work with atomic masses…

    2 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 →
  13. 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 →
  14. 1 vote
    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 →
  15. 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
    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 →
  16. 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 →
  17. Rounding should be a FORMAT and not just a function. The Round() function does the job but it is tedious to use.

    In the Format->Number, it should have another field for how many digits of rounding needed. For example -3 would round to 123,000.

    Also, # of significant digits is critical. For financials, 3 significant digits is plenty. Sometimes only 2 is needed. If less than sqrt(10), then 3 digits, otherwise 2 digits is the best (2.5 significant digits).

    0 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. In conditional formatting the top ten colour should be green as in market is up, the bottom ten should be pink as in market is down. Thank Y

    In conditional formatting, the top ten colour should be green as in market is up, the bottom ten should be pink as when the market is down.
    If the colour was fixed this would save time. Thank You.

    0 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. F4 function

    Hey - have an issue using F4 function to repeat font color and fill color in the latest Office 365 excel. Version detail as below -

    Office 365 MSO 16.0.12228.20232 64-bit
    Win10 Professional 1809 17763.379

    Issue is -

    pretty much everything action could be repeated using F4 except font color and fill color in this latest version Excel. The tricky thing is, if I'm going to repeat a fill color action without changing the default fill color (which is yellow) - it works. But as soon as I pick a different color from the fill color drop down menu, the…

    0 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 →
  20. Custom Cell Format Referencing Another Cell For Threshold

    Rather than manually adding a threshold value to a cell in custom cell format it would be useful to be able to reference another cell containing the value you wish to use.

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

Feedback and Knowledge Base