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. Make custom number formats available across workboooks / an application level setting

    I have a preferred number format that I use in many workbooks. Each time I introduce it into a workbook, I need to re-write the format string. Excel should make it available in the custom list automatically, given how much I use it.

    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 →
  2. Bring back 2 formatting shortcuts that were in older versions

    There are two in particular.
    1. When changing the format of the number on a chart & selecting "number" you have the option to specify the number of digits. There used to be up & down arrows to use the mouse to change the number of digits; you could keep your hand on the mouse & select the desired number of digits. Now you can only do this from the keyboard.
    2. It used to be possible to make a number of formatting changes to a curve, select a new curve, & press F4 to apply all of those formatting…

    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 →
  3. Improve Excel Profile usage options

    There are many great ways that Excel likes to be helpful. Often its helpfullness gets in the of a simple task such as entering a number. If there was a method of telling Excel that I am not a mathematician and I don't need my numbers turning into logarithmic formulas when I'm simply importing a datasheet for inventory, invoices, and tracking information. I understand that turning the column into text will prevent that from happening but it also turns other useful features. Maybe what asking for is more granularity options in the way Excel autocompletes information.

    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 →
  4. Allow me to change/set new defaults for CSV imports

    I have several CSV files each day to import into an excel spreadsheet. I need the formatting to remain the same in the cells into which they are imported. Calculations and other things are done based formulae I have set.

    Every import I have to change the default from "Adjust column width" (1st screen shot) to the second screen shot.

    I don't want the columns adjusted...that messes up the column label.

    Please make it so I can choose "as default" to not adjust columns.

    You can see screenshots here.... http://answers.microsoft.com/en-us/office/forum/office_365hp-excel/import-default-for-csv-files-id-like-to-have/ed89322d-6e6e-41f7-ae67-94c6846d2c40

    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 →
  5. 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 →
  6. Lock conditionnal formating ranges

    If people copy/paste cells with conditionnal formating, the start range for apply formating change.
    You must look for the cells without formating, or re-create the formating range.

    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 →
  7. Add 'duplicate' or 'repeat' to right-click menu

    To insert a copy of selected rows or columns requires: select - copy (ctrl-c) - right click - insert copied cells.

    How about: select - right click - insert selection above

    5 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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.

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

    We’ll send you updates on this idea

    8 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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 →
  18. 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 →
  19. 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 →
  20. Minimum Row Height

    I can currently set the row height to be automatic or set it to a fixed height. When working with tables which contain text, this often leads to a mishmash where rows are randomly one, two and sometimes three rows of text tall. This looks sloppy. I can manually review and set the row height for each row, but why should I have to.

    I should be able to set the row height to a minimum value. If the row needs to be taller to fully display a cell with wrapped text, then the row height should automagically increase. This…

    6 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