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. Auto outline based on the level specified in a cell

    There are many types of data which requires hierarchical presentation using outlining.

    Unfortunately, current Auto outline is based on subtotals which ties it only to tables which summarize numerical data (every outline tutorial on the Web based on sales examples). Other data types require either manual outlining (which is basically useless in case of frequent changes) or VB macros.

    It would be very useful to be able to to auto outline data based on the level specified on a certain column similar to how Word outlines headers based on list numbers. See attached file.

    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. Make cell style a valid criteria for logical functions!

    Let's say I want to find all the "good" styled cells in a column and add up their values. Normally, I could use a sumif function, but as far as I know, excel does not support cell style as a logical criterion. Allowing this would let me use sumif to pick all the "good" cells in a column and add them. Tying this in with conditional formatting, using rules to set good or bad cells, would make functions and formatting tie in quite nicely.

    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 →
  3. Add multi tick mark tool in Format Axis (Tick Marks)

    Let`s consider a plot with Two vertical axes and One Horizontal axis and if I want to have the same tick marks pattern for all of the Three axes then it would be great if I have the tool which can copy the tick mark format of one axis can apply to other axes simultaneously.

    (Format axis-Axis options-Tick marks)

    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. Please bring back the ability to keep the color palette open while working.

    Please bring back the ability to keep the color palette open while working. I miss it so much! It's an old ability that deserves a comeback

    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. Page border in excel

    We should have option of Page border in excel (like Ms Word)

    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. Graph Paper should be an option for Excel,,, that is actually square.

    On tool bar, choose "Graph Paper" to be provided with row heights and column widths that are in the same units, so that you can choose sizes for to make graph paper with cells that are true square.

    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. Conditional format cells based on the 'time' value entered

    Be able to conditional format cells based on the time value entered and when the current time matches that of the cell, it gets highlighted or a symbol appears.

    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. Needed to fix copy paste the tables from excel to outlook

    Copying from excel to Outlook (or any other app) should keep the content and format, borders, alignment of the cells. It takes so much time to adjust everything after pasting data into an Outlook e-mail, for example...

    1 vote
    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 →
  9. have an 'A' number formatting option as adding machines do, so don't have to enter '.' all the time.

    know excel was to be scientific, but bet it is used in 'financial' spreadsheets more than inventors could have envisioned.
    'A' on adding machine, means 12 equals 12.00 saves 3 keys

                                                    12.1               12.10  saves 1 key
    
    1210 12.10 saves 1 key
    12.10 12.10 saves 0 keys

    1 vote
    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. Change First Letter Capitalization in Dates (In any language)

    I was working on a table with dates and I found a hard time trying to capitalize the first letter of a date. I noticed that in english dates, going in the custom format and adding ;@ would do the job. However, I was working with data in portuguese.

    I found out a solution, derived from a support post in Microsoft. The solution would be to use this code: =PROPER(TEXT(Cell Selected,"[$-pt-BR]mmm/yyyy")) You would be able to use it clearer in any date format. And to change to the language you're working, I believe you would have to change from 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 →
  11. Enable Fill Handle Default

    This is not exactly a new idea but, it is a much needed improvement.

    While the fill handle is a great tool, it would be much more useful if you didn't have to enable it every 2 minutes while working in the same Excel document.

    Please allow the user to set Enable Fill Handle as a default setting so they don't have to re-enable it. . . ever.

    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. Once my form columns & lines are set-up. I would like to be able to drag cell formats vert. or horiz. WITHOUT disturbing the lines!nes!

    Once my form column & row borders are established; I would like to be able to duplicate cell calculation formats, by dragging either vertically or horizontally WITHOUT disturbing the existing column or row borders' i.e., WTHOUT bringing cell border format along! In other words, I want to be able to drag cell function formatting into new territory, WITHOUT having to redo the border formatrting each time I expand, correct or revise my form. Please advise?

    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. Can you please give the users freedom to change icon colors while using conditional formatting. This is cruel to not give format icon set op

    Can you please give the users freedom to change icon colors while using conditional formatting. This is cruel to not give format icon set option

    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. Allowing for hyperlinks to be placed into the 3D maps software for easier integration to the excel workbook

    I am currently working on making a master list of Distributors in the US for the company I work for, I am using the 3D map to showcase the locations of the distributors. I only wish I could allow for a link to the data in the workbook where more information is given. To work around this I made a search page to sort through the data table. This change would make the map feature feel more streamline.

    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. Replace all previous keyboard shortcuts, especially Alt+E A to clear a cell.

    Replace all previous keyboard shortcuts, especially Alt+E A to clear a 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 →
  16. Easy 'collapse all' (rows/cols) functionality without losing wrap text, grouping, and automated cell sizing functionality.

    Similar to the grouping functionality on excel spreadsheets where you can easily collapse by group / ungroup areas by rows or columns for larger sheets, then it would also be great if you could simply 'narrow' all of the rows or all of the columns to a certain size despite there content, to enable easier review of large sheets with a lot of info in each cell. i.e. an easy 'collapse all' functionality without losing wrap text, grouping, and automated cell sizing functionality.

    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. Provide additional text formatting options.

    For cells formatted as Text, I would like to be able to specify text formatting similar to the options provided by the "Change case" function in Word (e.g. Sentence case, lower case, upper case, or capitalize each word).

    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 →
  18. Please provide an easy way to specify the total width of a range of columns

    It would be helpful to be able to set a fixed width for a selected range of columns. I would like to be able to select the columns that I intend to use and specify the total width for those columns so that they fit within the page margins. A "Fit to Page" option to make the total width of the selected columns always be equal to the width between the margins would really be nice and that would be most useful to me, but if possible I think it would sometimes be useful to be able to set a…

    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 →
  19. borders

    I have worked in Excel for years - one thing I am always frustrated with is if I move information in a field whether it is copy paste or click and hold the border comes with it. I then have to stop and fix border. Could you provide a way or is there a way to firm the borders so they do not modify when data is moved?

    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 →
  20. BUG: Text formatting results in complete freezing of my screen

    EVERY SINGLE TIME I try to press ctrl+B or use the text formatting toolbar my app will freeze for up to 10 minutes. Occasionally it will move out the spinning wheel phase, but I'd say that I have to force quit in order to continue doing anything on my computer.

    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