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. Bioinformatics: gene names errors

    http://www.ncbi.nlm.nih.gov/pmc/articles/PMC459209/
    http://www.ncbi.nlm.nih.gov/pmc/articles/PMC459209/bin/1471-2105-5-80-1.jpg

    i have recently noticed this while trying to modify a dataset in excel and importing it back into R, which throws the duplicate rowname error (e.g. sep1 and sept1 get automatically formatted into the same values).

    this is a really minor nuisance because most of the work is done in R, and maybe it's better addressed by guys at R. i dunno

    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

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

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

    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

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

    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. Copy and Paste Row Size

    Currently, there's the option to copy the size of a column and paste the width of that column to other columns in a sheet. However, there is no such option if you wanted to copy and paste the height of a row. This would be very valuable. Thanks!

    15 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

    7 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Cell formatting - bitmap fill

    Not essential, but would be nice to have...
    Please allow a cell (or multiple cells) to be filled with a bitmap image. Options could allow for the bitmap to automatically resize to fill the entire cell, or alternatively, for the bitmap to retain it's aspect ratio within a cell.

    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 →
  7. Cell tag

    It would be good to have Cell Tags, invisible tags which are assigned a colour so that when you click on a cell it fires an event and you can perform a function like drill down to a page, view a subset etc any event really.

    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 →
  8. 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

    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 →
  9. Need a way to find the cell my cursor is in. The user should have an option to pick a way to highlight the current cell the cursor is in.

    I want to be able to easily find when my cursor is. The current pale and lame way of minimally highlighting the column/row edge is not sufficiently visible to easily find it. If I am working on a large sheet and I move from one application to the next - it takes me a long time to find the cell I was working in. There's gotta be a way to provide the user with more flexibility in selecting colors for how to highlight the cell the cursor is in - whether the window is active or not. If I move…

    14 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

    7 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Select protected/unprotected cells

    In the menu Home > Find & Select > Go to Special, you have many pretty interest way to select cells (formula, blank, ...)

    I would like to add to this tool the option protected and unprotected cells.

    10 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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add an easy way (Ribbon button) to change text casing (UPPER, lower, Sentence, etc.)

    Currently Excel is the only Office application that doesn't have the ribbon-button to change selected text to uppercase or lowercase.
    The only way to do it is to use the function =UPPER() and then copy/paste the resulted value into the original cell.
    It would be good to have a button to change the selected text to uppercase or lowercase.

    111 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

    48 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. Allow us to customise the "right-click menu option"

    We are already able to customise the ribbon menus. It would be great if we could also customise the right-click menu options. In particular the following would be useful:


    • Conditional formatting

    • Styles

    However, add these may make it too cluttered for some users, so it would be great if you could choose what items are shown.

    This is an extension of this idea by Emma...
    http://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10669878-right-click-for-conditional-formatting

    10 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

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Give us a "Center Across Selection" option for the Vertical text alignment

    "Center Across Selection" is available for Horizontal text alignment but not for Vertical text alignment.

    This would be useful for heading columns where the text is rotated through 90 degrees and spans more than one row.

    63 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

    11 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Alternative number systems as formatting (in particular, binary, octal, and hexadecimal)

    The main problem with DEC2BIN, DEC2OCT, and DEC2HEX is that they return text. If you want to do an operation on the "numbers" returned by those functions, you have to operate on the original decimal numbers and use the same conversion function on that. It is impossible to work directly in that alternative number system.

    Instead, we should just be able to change the appearance of a decimal number through formatting and do our math on that. There can of course be an indicator of the number system as part of the formatting, probably a subscript.

    9 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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow us to make and add custom border styles to the list of default borders

    I'm tired of clicking the different default borders a bunch of times or going into the "more borders" sub-menu to get what I want. The default borders are great, but I really wish there was a way to create our own border style and have it listed with the defaults. Too often, I find myself going to "more borders" to do 1) both diagonals to "X" the cell and 2) a thick box border on the perimeter and standard thickness border on the inside.

    I suppose these could come standard with the software, but I assume everyone has their own…

    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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Tight column fit + wrap text + row autofit = autofit to 1 line more

    If you have text in a cell and apply the Wrap Text formatting and then resize the column so that one of the words is close to wrapping onto the next line, then when you autofit the row, the row's height will be as if you have 1 more line than you actually have in the cell.

    For example, on a new sheet, if you type "One" (without quotes) in any cell and resize the column to 31 or 32 pixels, then the row will be 2 lines big after autofitting, but "One" still only occupies 1 line. I am…

    5 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

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. Ordinal Number Format

    How about an option to format as ordinal numbers, similar to what can be done in fields in word with *Ordinal

    7 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

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. "Clear all" feature should be clearer to spot (and have shortcut)

    I teach excel, and it feels like around 90% of students (daily Excel users) don't know the clear all function exists. Also when someone press the delete key, 90% of the time, they mean to press clear all, they just don't know it exists, so they then remove the fill, change the colour, delete borders, unmerge cells etc, These all take many clicks.

    I truly believe that MOST Excel users waste time every day because they don't know of the existence of "Clear all". Excel should make this really obvious by 1. Adding a keyboard shortcut (Shift + Delete maybe?)…

    24 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

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

    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

    6 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Case Sensitive Date Format Rules

    I wish the cell formatting rules for dates were case sensitive. For example, the rule "MMM" outputs "Jan" instead of "JAN"

    8 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

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base