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. Please fix! Conditional formatting does not work when the cell value is based on a complex formula

    Conditional formatting of cells based on their values fails when the cell value is a number calculated using complex formulas, specifically when the number is extracted from a string of text in another cell.

    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. Freeze Pain

    Your freeze pane feature is more a freeze pain. Please rewrite the program to allow for any number of highlighted columns and rows to freeze, and at the users options and discretion too. Not what you want or deem appropriate for the user to use.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. Selected Chart Data Labels Missing Selection Handles

    Selecting a chart's data label(s) should display all labels with selection handles. Instead, some of the data labels are not showing as selected, even though they actually are selected (as evidenced by making a font change and seeing that all data labels are affected!)

    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 →
  4. Add "Invert if Negative" color Format Axis

    When formatting Charts the Format Data Series Fill includes the ability "Invert if negative"

    Please add Format Axix Fill to include same ability to "Invert if negative"

    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. I find it strange that Excel in Office 365 does not have Rupee symbol in Indian Language option. Do'nt you think it is high time it should?

    It is high time Indian Rupee Symbol and the way use number should be part of Windows and Office immediately.

    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 →
  6. A tool is needed for auditing Conditional Formatting formulae

    Conditional formatting allows a formula as part of a rule, and that formula may refer to another cell in the workbook. If that other cell is deleted, then a #REF error creeps into the conditional formatting formula.
    Of course a properly constructed formula would allow for such circumstances, but there is no simple method to check the conditional formatting rules to validate them.
    It would be helpful to have a way to download the conditional formatting rules to allow the programmer to audit those rules.

    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 →
  7. Allow Charts To Contain Multiple X Labels

    Allow bar (and other) charts to contain Multiple X axis labels.
    Stack the labels on the chart in the user specified order.
    The dialog box (see attached file) could simply have a button with a Plus sign to add another label. Of course arrows to arrange the label order along with a button to remove the extra label would be useful.

    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 →
  8. When a range of cells is selected with the bottom border icon selected in the Font ribbon, apply the bottom border to ALL selected cells.

    When a range of cells is selected with the Bottom Border icon selected in the Font ribbon, apply the bottom border to ALL selected cells. This should also be applied for any cell borders indicated by the icon.

    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 →
  9. Add Shape Format Selection Pane Right Click Context Menus

    Add a Right Click Context Menu in the Selection Pane.
    When I right click, show options to Align, Group, Bring Forward, etc.

    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 →
  10. image in cell

    Inserting images in Excel, it must be a little easier to insert pictures of which we have a weblink for.

    i.e. making a list of LinkedIn contacts, where you would like to insert the profile picture (weblink available from LinkedIn page) into a cell that is already sized. The picture should fit INSIDE the cell, NOT over the cell.

    Check out Google Docs, they have this exact function. I would really like to see MS do the same, if not better.

    Google doc also allows for the insertion via formula:
    =image("[insert link]")

    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 →
  11. Number display to desired significant figures

    Add the ability to display a number to a specific number of significant digits or significant figures. This is different from a specific number of decimal places. There are various ways around this in Excel, but they are all clunky, especially considering that it's 2019 and this feature is available in some other programs, such as Matlab.

    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 →
  12. "Number" format cells > move decimal > WANT ROUND to TENS, HUNDREDS, etc.

    Want to be able to move the DISPLAYED DECIMAL point to the LEFT of the actual decimal point, such that Excel would effectively keep ROUNDING OFF DIGITS & POWERS OF TEN

    e.g.
    123.456
    123.46
    123.5
    124
    120
    100

    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 →
  13. Add Pop-up charts

    Enable the ability to hyperlink a cell to a popup chart that opens in it's own window.

    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 →
  14. Add change case functionality form upper to lower and vice verse

    allow text transformation from upper case to lower case through clickable icon.

    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 →
  15. Add conventional boolean criteria to iCon Conditional Formats

    Conditional formatting using iCon sets should include additional criteria. Currently we can only select >=, or > to compare value to a number, or formula (e.g. cell reference).
    Enable ability to choose icon when a value is equal (e.g. =) to a value (that can be defined in a cell reference)>

    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 →
  16. Add number format for thousandth (K$) or millions (M$)

    Could you please add the number format K for thousandth and M for millions (like 5.8 K instead of 5812)
    It would be very helpful.
    Thanks

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

    We’ll send you updates on this idea

    5 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add week (w, ww) to date format

    Allow use w or ww in date format, aplying ISO 8601:

    Example:

    28/Dec/2003, "aaaa/ww" results 2003/52
    29/Dec/2003, "aaaa/ww" results 2004/01

    Thanks

    4 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. Conditional Formatting formulas don't work

    I want to use =If(And( . . .
    for Conditional Formatting. It does not work and Excel states that there in a error in the formula. Please fix .
    MS Office Professional Plus 2016

    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 →
  19. Shortcut for double clicking format painter (to lock and unlock selection).

    I have the format painter selection on my quick access toolbar, and I just need to click Alt +3 to activate the format painter tool.

    The issue is that whenever I want to copy a cell's format to other cells scattered through a spreadsheet, I need to keep clicking Alt +3. I end up pressing Alt +3 many thousands of times a week. (Yes - I know how to paste formats).

    Solution: Have a function called "Lock Format Painter" that I can add to my quick access bar as the forth tool, so I need to just press Alt+4 whenever…

    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 →
  20. Date formating

    Don't have it change the ******* date format to anything other than what I have typed into the block.

    7 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