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

    12 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 →
  2. Provide a quick option to toggle the visibility of zero values within the Ribbon. This feature belongs in the View tab of the ribbon, not b

    Provide a quick option to toggle the visibility of zero values within the Ribbon. This feature more logically belongs in the View tab of the ribbon, not buried in File\Options\Advanced\Display Options for this Worksheet. I have created a macro in the Personal Macro Workbook and added a button to the QAT to do this :

    Sub ToggleVewZeros()
    ' Toggles view zeros on and off

    If ActiveWindow.DisplayZeros = False Then
    
    ActiveWindow.DisplayZeros = True
    Else
    ActiveWindow.DisplayZeros = False
    End If

    End Sub

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

    In engineering, it is very common to use scientific notation that only displays numbers in factors of 10e-6, 10e-3, 10e0, 10e3, 10e6, 10e9, etc. I've seen this called "engineering notation" - it's just a special subset of scientific notation.

    It would be great to have an extra formatting option for this.

    For example:
    1.3e5 would be displayed as 130.0e3
    2.0e6 would be displayed as 2.0e6 (no change)
    3.2e10 would be displayed as 32.0e9

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

    We’ll send you updates on this idea

    12 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Why did you change default Excel document colors from older versions?

    Why did you change default Excel document colors from older versions?

    When I open up an older file and need to update it, the available default colors for cells, tabs, etc. is different from versions past.

    Why???

    This makes it EXTREMELY inconvenient and most ANNOYING when doing changes that we want to make match the documents as we edit them. Right now I'm going through an Excel document and trying to match not less than 10 colors for cells and tabs, making changes in Excel's color selection for future changes to this document's and others' once Excel default colors from…

    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 →
  5. 44 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Conditional formatting suggestion – managing

    This worksheet choice should appear first
    Whenever I have to check on the conditional formatting and clicking ‘manage rules’, the first thing that comes up is the Current selection for the formatting rules. I think it should be ‘this worksheet’.

    8 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 →
  7. Drop Down List

    How about making the drop down list show more than 10 items at a time without having to scroll? Many years ago when using Excel for Mac, the drop down list would run the length of the screen. Not sure if this was a feature specific to Mac, but it would make using drop down lists a lot more useful on a PC.

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

    We’ll send you updates on this idea

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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
    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 →
  9. 'No cell overflow' setting

    In reports, tables or pivot tables, when the following both conditions are filled:
    - a cell contain text that is longer than the width of the cell, AND
    - the next cell on the row is empty
    Then the text of the first cell overflows in the next cell, making reports not presentable.

    Eg:

    Cust Name Jan Feb _Mar


    1 CustomerA $123 $432 $654
    2 CustomerB $876 $676 $365
    3 CustomerC $033 $443 $553
    4 CustomerD ____ $234
    5 Long CustomerE Name $543
    6 CustomerF $876 $676 $365

    row 4 & 5 : customers have no sales in Jan or…

    5 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 →
  10. Provide a way to format text as basis points

    In the financial world it is common to express percentage values as basis points. Currently there is no way to format a percentage as basis points without multiplying it by 10,000 (which then changes the value and you can't use it in calculations).
    Essentially you need to have the effect of entering % in the Custom Format without actually have "%" appear in the cell.

    4 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 →
  11. Keep cell formatting when removing hyperlink

    When entering an URL in a cell, Excel will automatically add an hyper-link on the text. However clicking "remove hyperlink" will also remove any formatting that we may have set before (colours, borders).

    This is extremely annoying when dealing with spreadsheets comporting a lot of URLs. It would be better if removing the hyper-link would keep the initial formatting of the cell. Or at least being able to tell Excel that we do not want to automatically add hyper-links on the cells.

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

    9 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. Make vertical alignment default to top of cell

    If any column has text wrapping applied, top of cell formatting makes data much easier to read, both on screen and printed version (especially if there are no borders)

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

    We’ll send you updates on this idea

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add A Color Picker Tool

    A simple color picker tool has been something I have been forever longing for! It would be so nice to have the ability to grab colors from an image on the fly instead of having to use a third-party tool and manually type in the RGB code.

    I envision this being an Office Suite feature, where you could grab colors from say a PowerPoint slide or even a web page and fill your selected cells with the exact color.

    If you wanted to get really fancy, you could even have a column in the pre-formatted Ribbon galleries to update one-click…

    11 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 →
  15. 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
    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 →
  16. Right click for conditional formatting

    Please add the conditional formatting menu to the options available when you right click a cell.

    10 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. Moving Tabs

    In the activate window when you right click the arrows it lists all the tabs,I would think the ability to rearrange the tab order in that window would be useful. This could be done by drag or highlighting a clicking an arrow.

    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 →
  18. 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
    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 →
  19. 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
    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 →
  20. Change Default Auto Fill Option

    Currently Double Clicking the bottom right corner of a cell will Auto Fill down to the last populated row in a data sheet. However in doing so it defaults to 'Fill Series' e.g. 1,2,3,4... it would be great to set the default to, say, 'Copy Cells' e.g. 1,1,1,1...

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

Feedback and Knowledge Base