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. Use conditional formatting on checkboxes

    In stead of letting the checkbox control other cell's format, allow excel to format the checkbox depending on if it's checked or not.
    This could come in handy when following up on a long list

    1 vote

    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 →
  2. Arrows for increase or decrease decimal

    The arrows are not correct here and very confusing how you draw this.
    When you go from .0 to .01 it actually should have an arrow pointing to the right, not left. You are adding decimal places. It is odd that you have the arrow to the left for this.

    So when you go from .01 to .0 it is actually reducing the decimal places so the arrow should be to the left direction! Also, you should line up the decimal places. You have it backwards. Not sure who designed this, but it has always messed me up. It isnt…

    1 vote

    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 →
  3. Paste Special option to paste as Text or as a Number

    It would be incredibly helpful to have, as a Paste Special option, the ability to paste as text or as a number. By this, I mean pasting as data type 1 or data type 2. This would save the user from having to manually convert data with the TEXT function or by multiplying by 1 (depending on the data type to which he is trying to convert his data). This would also allow the data to be converted in-place rather than using a helper column or Text to Columns.

    1 vote

    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 →
  4. Asterisk

    Allow for a format of a cell to contain an asterisk after the number as opposed to entering in a separate cell.

    1 vote

    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. enable subscripting superscripting in axis titles

    enable subscripting superscripting in axis titles

    1 vote

    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 →
  6. flip a worksheet across a diagonal

    Occasionally I set up a worksheet with, for example 10 rows, and I keep on adding new columns of data to the right, until I have for example 100 columns. By that time, I might wish that I had started off with 10 columns, and added new data by adding new rows at the bottom of the sheet. Unfortunately, there seems to be no way to change the orientation of an existing worksheet automatically, with one easy command. Or at least I can't find a way to do this.

    I would like to be able to do the following:
    Select…

    1 vote

    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. Digit Grouping in Excel

    We need to have an option to change digit grouping in excel for a particular workbook. This is very helpful when we are working in multiple currencies. If we are using US Dollars, we should be able to have digit grouping of 3 digits, i.e. millions, e.g. 123,456,789.00. If we are using Indian Rupees, we should be able to have digit grouping of millions or crores, as we wish, e.g. 123,456,789.00 or 12,34,56,789.00. Currently the only way to make the change of digit grouping is to change digit grouping through Region settings in Windows.

    1 vote

    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 →
  8. Provide an option to format a cell as text, all upper case.

    Excel (I am using Office 365) NEEDS to provide an option to format cells as text, upper case only, so that all text entered is converted to upper case. Providing the same text formatting options as Word (i.e. Upper Case, Lower Case, Capitalize only the first character of each word, etc.) would really make sense and be welcome by all Excel users, but at minimum Upper Case Only is an absolute necessity.

    1 vote

    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. The ability to count the number of cells by a specific color

    The ability to count the number of cells by a specific color. I use fill to keep track of tasks who they are assigned to and which ones have and have not been completed.

    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. Treat empty value in Format Cell -> Decimal places as 0

    Hello,

    Background


    1. Press CTRL+1 or RMB -> Format cell.


    2. Navigate to either Number, Currency or Accounting category.


    3. Leave "Decimal places" field empty.


    4. Press OK.


    Problem

    Whenever you empty "Decimal Places" field you can't go on because error is raised "Your entry cannot be used".

    This is annoying because empty field and 0 have the same meaning in this context.
    I noticed that majority of the people using backspace intuitively to make this field empty meaning no decimal places is expected aka 0 but facing with an error message described above.

    Proposal

    Make empty field and field with 0 value behave…

    1 vote

    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. Button to set cell to Number in comma format, with zero decimal places

    I personally don't like Accounting number format, but "comma" button only applies to it. Wish we had similar button, or way to construct one, that did same with Number format, and zero decimal places would be icing on the cake.

    1 vote

    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 →
  12. Please change the default format for the $ in format box to Currency instead of Accounting

    I would like to have quick access to the number formats I use the most so I don't have to click on the dropdown, select more number formats and then pick the options I want.

    1 vote

    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 →
  13. Ability to Define Exact Display Position of Notes/Comments

    We've asked for this for a decade!

    When you insert a cell comment/note, you should be able to define the exact display positioning for that comment or note on the active window, possibly by defining position relative to the cell, or an upper left coordinate, or otherwise.

    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 →
  14. draw the circle around the cell

    add feature that can circle the cell. highlighter doesn't work with B&W printer so need to draw the circle around the cell to be noticed

    1 vote

    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. An option to change the default paste style like in MS Word

    I'm currently copy-pasting data from a website into a spreadsheet, and have to use the drop-down menu every time to match destination formatting. I've looked for a way to change the default-- but I can't find one.
    It'd save a lot of time and effort if we could have an option like we do in Word to change the default paste style-- please help!

    Thank you very much for your time.

    1 vote

    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 →
  16. Fix issue with not being able to set NumberFormat for DataLabels in Treemap chart

    Fix issue with not being able to set NumberFormat for DataLabels in Treemap chart. Cannot set number format for series in Treemap charts but can for all other chart types.

    1 vote

    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 →
  17. Fix issue with not being able to set NumberFormat for DataLabels in Treemap chart

    Fix issue with not being able to set NumberFormat for DataLabels in Treemap chart. Cannot set number format for series in Treemap charts but can for all other chart types.

    0 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. 1 vote

    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. explain what this error means (((0-0)))

    I need the information concealed by these symbols

    1 vote

    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 →
  20. Please make the default for columns number or text

    Please make it so CSVs upon opening do not immediately reformat to dates. "5-20" immediately converts to dates no matter what I do to the CSV before opening. Very frustrating

    1 vote

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

Feedback and Knowledge Base