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. Can a date/time stamp along with the user info be allowed to be shown for each cell that is edited (populated)?

    I want to be able to hover over a cell and get a sense of who/when it was updated. I can possibly modify global properties within the worksheet/spreadsheet to be able to view it or turn it off.
    I often make edits within a spreadsheet that stores date/time based information ( e.g. FF miles or Hotel points ) and then have to put a date on the cell ( next to it ) to remind me the date of edits.

    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. Create new table without any formatting

    When you create new table by default some formating and table stiles are applied. You have option to click "clear" in design tab. That command clears all formatting; color, background color, etc. But it does not change column width back. New column width stays.

    I would like "clear" option to change column with back to the width before table formatting was applied. New column with, when create table is applied, can mess up your file when you import data from outer sources or when you need column with to be persistent.

    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 →
  3. Paste Match destination option greyed out in excel 2016 , but avilable in excel 2010

    Paste match destination option is available in excel 2010 and not in 2016 . This option had been greyed out in excel 2016 . Due to lack of this option, the data can't be copied from one excel workbook to another workbook in the required format as the instances created are distinct. ( i.e. The numbers are copied in "text format" rather than number format.) Paste destination option can eliminate the above issue and get the date copied in the required format by the user.

    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. Allow grouping of tabs in Excel

    Have an option in Excel to allow for grouping of tabs into sub-groups, and have them stack behind the main tab. clicking on the main would allow you to expand or collapse it's sub tabs. You could also promote a sub tab to main.

    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. Keep grid display for cells formatted with a color fill

    Something that has aggravated me longer than anything else:

    Leave the gridline display for cells one formats with a color or pattern fill turned on:

    For at least 30 years, the gridlines around the cell are turned off when the format is applied. One must replace them with actual cell borders which, I might mention, do NOT go away themselves if the color or pattern fill is removed. Oh, and select slightly the wrong color for the borders one is adding and it all looks subtly bad.

    Simple enough to add a checkbox to the formatting tab to clear the…

    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. Problem to be fixed: a cell will reformat (from three to 14 decimal places) if I raise a non-integer to a non-integer power (1.3^0.75).

    Problem to be fixed: a cell that I format to show a number to three decimal places will reformat to 14 decimal places if I raise a non-integer to a non-integer power. Example: Cell D7 = 0.75; Cell E7 = 1.2; Cell F7 (which is formatted to three decimal places) = E7 ^ D7

    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 →
  7. Conditonal formatting for pivot table row and column labels

    Excel allows conditional formatting for pivot table data that automatically updates on refresh.

    It would be good to have similar functionality for conditional formatting of the row and column headers.

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

    In Home Tab, Editing Group add command that convets formulas to values and add command clear conditional formating
    Besnik Skenderi

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

    In Home Tab, Editing Group add command that converts formulas to values and add command clear conditional formatting

    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. Allow someone to format Cell data as JSON

    When someone posts a data in excel cell like

    { Object A { Object B, Object C { Object D}}} , then cell "JSON formatting" (if available) shall format it like

    {
    Object A
    {
    Object B
    Object C
    {
    Object D
    }
    }
    }

    There are many open source toll which provide this feature of inputting json body and get a beautified version (like https://jsonformatter.curiousconcept.com/).
    If we can do JSON format in excel cell, it will help many people.
    In fact people will use excel just to format data as its readily available in many windows platform.

    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. Merge cells optically, but not functionally.

    Merging cells has the drawback, that it cuts the functionality of the excel file.
    So why not implementing a functionality, that merges cells ONLY OPTICALLY, so that the cells still keep their value and thus the full functionality, but that excel recognizes, when cells in rows that are directly located under the each other, contain the same values and thus just merges the cells optically, but does not merge the values, so that the user sees the merged cells on his monitor, and is able to print the table with merged cells, but still can e.g. sort the rows in…

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

    We’ll send you updates on this idea

    7 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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. Stop using d-mmm as the default date format when data entered is ##/##

    Please make the default use of "d-mmm" go away. Nobody uses this date format. Nobody. Ever.

    When "6/12" is entered, the default should be mm/dd/yyyy (or whatever the regional settings dictate).

    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 →
  14. Conditional Formatting - set formats from an specific cell (ex. formating = $A$1)

    That could be really great if Conditional Formatting was an option to set formating = specific cell formating. (example: if [condition]... formating = as $A$1)

    So I mustn't go through all Rules descriptions and edit every detail again and again (probably - just to see, which colors look better :) )

    With this option, it would be enough to set conditional formatting once*, and if I change the format for those cells I have selected in CF for formats, other cells (depending on conditions) would change their formatting automatically.

    (*- of course, if conditions and areas stay the same)

    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. Shortcut to custom formats in quick access olbar

    I use a custom format that looks like currency but has dashes instead of zeroes, I'd love to be able to have a shortcut to access that format by pressing Alt+3, for example, on the quick access toolbar. The should also be a shortcut to refer to the currency format, which is a default format! Also, you should be able to define format preferences - I'd love to indicate that whenever I use the currency format, apply it with no decimals and center the formatting.

    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. Blur fields. Should have the ability to share a spreadsheet with someone and blur out fields with sensitive data.

    Blur fields. Should have the ability to share a spreadsheet with someone and blur out fields with sensitive data.

    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 →
  17. Optional setting to limit the size of your file (ex. all info must be on page 1)

    Optional setting to limit the size of your file (ex. all info must be on page 1 or limit columns allowed from A to G only - H-infinity are blocked). This allows similar printouts to Microsoft Word with benefit of using columns, rows, tables, etc from excel.

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

Feedback and Knowledge Base