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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Grouping/Outlining [-] Button should be at the top (or both bottom and top)

    Currently, when you group rows using the grouping and outlining feature, the [-] toggle for the group shows up only at the last row of the group. This means that after you click on the [+] button, the [-] doesn't replace the [+] button but shows up at the bottom of the list. This requires the user to scroll down to find the bottom row of the group and click on [-]. And then scroll back up to find the top row again.

    When quickly expanding and contracting groups, it would require a lot less mouse movement and scrolling if…

    2 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      4 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

      This is already doable using the outlining options. Additionally – you can click anywhere on the outlining line to expand/collapse.

      Cheers,
      Dan [MS]

    • Standard Customized Charts

      I am currently using Office 2010, I would love to have the possibility to create, for example, my personal line chart, with the dimension, layout, axes formats and so on stuff already standardized.
      Something like a "Browse for template" but for charts :)

      Cheers!

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

        You can already create a “chart template format” and apply that to charts that you create in the future. To do it, follow these steps (from Excel 2016, but I think the 2010 steps are the same/similar):

        1. Create the chart you want (all the series, etc.)
        2. Format the chart the way you want it formatted (colors, font sizes, etc.)
        3. Right click on the chart and choose “Save as Template…” in the context menu. Save the crtx file in the suggested location.

        4. Now, create a new chart, give it all the data you want, but don’t worry about formatting anything.
        5. Select the chart and on the Chart Tools > Design Ribbon, choose Change Chart Type
        6. In the Change Chart Type dialog, select the “All Charts” tab at the top
        7. In the list of chart types on the left, choose “Templates”

        Now, you’ll see the…

      • Circular Errors

        I had to look all over the worksheet headers to find an option that would show the cell being questioned. You get this error when you are about to save and leave a worksheet. I do not usually have time to go hunting for it at that point. Need a quicker way to identify the specific problem cell.

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          3 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

          Hi,

          This is already supported in Excel.

          Go to the Formulas tab, Error Checking, Circular References. You’ll get a list of cells involved in circular references.

          Cheers,
          Dan [MS]

        • You could bring back the pathway on the tool bar to creat new work books. YOU TOOK THAT OFF AND IT MAKES IT VERY DIFFICULT.

          wE WERE ABLE TO CLIK ONTO NEW WORK ON LEFT SIDE OF TOOL BAR AND IT COPIED AND MADE NEW WORK BOOK INSTANTLY

          2 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            2 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

            Hi,

            This is already supported by customizing the QAT and adding the “Document Location” control to it.

            To do that:
            1. File > Options > Quick Access Toolbar
            2. In “Choose commands from” select “All commands”
            3. Find the “Document Location” command and add it to the QAT by clicking the “Add >>” button.

            Hope that helps,
            Dan [MS]

          • "Ctrl+O" should open the Open File dialog box not the Recent File pane

            "Ctrl+O" has been an incredibly useful keyboard shortcut for two decades. Changing its functionality and moving the old functionality to Alt, F, O, O is a huge detraction from the functionality of Excel.

            I open 10 to 20 files a day. of those, only 3 tend to be files which were recently opened. When I open those, the Recent File pane is nice. When I open the other 17, the recent file pane is just wasting my time.

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              3 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

              Hi Kevin,

              You can get Ctrl+O to open the dialog box and not the backstage by going to File > Options > Save > Save workbooks > Don’t show the Backstage when opening or saving files.

              Check that box, and you’ll see the behavior you want.

              Personally, since I like the backstage for some things, I’ve gotten used to using Ctrl+F12 to jump directly to the Open dialog, and F12 to jump directly to Save – so that’s another option for you.

              Cheers,
              Dan [MS]

            • When saving a new file or using "Save as", list all the file names in the folder that is selected, not just files that Excel knows.

              I often create related files for the same topic. For example, I may create a word document and then want to create a related Excel file that contains related data, and I want to give both the same name. I would like to see this capability in all the Office products. These products used to work this way.

              3 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
              • Use Office standard of Ctr+Shift+C/V to cut & paste cell style

                Many Office apps allow you to select text style with a Ctrl+Shift+C, and paste it with Ctrl+Shift+V. Implementing this in Excel for the Format Painter would eliminate a relatively slow mouse-heavy operation.

                3 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

                  Excel already supports this. Simply Ctrl+C to copy the format you want, and then Ctrl+Alt+V, T to paste formatting. (That’s Past Special > Formats)

                  Cheers,
                  Dan [MS]

                • Create short cut for creating dynamic Charts in excel 2016

                  Create short cut for creating dynamic Charts in excel 2016.
                  The current process is long and not comfortable. in my opinion an easy way will make it a must.

                  This is how you do it in the old way http://www.criticaltosuccess.com/dynamic-charts-in-excel-resize-with-offset-function-named-ranges/

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

                    This has been supported for the last several versions of Excel if you use a Table as your data source for the chart.

                    Thanks,
                    Scott [MSFT]

                  • Make Excel window grabbing (and moving) painless

                    I just upgraded from Excel 2007 to 2016 on Win10. I am amazed how the user interface has degraded. I just spent about 5 minutes trying to grab the Excel window I'd moved to the top of my monitor's screen (so that workbook was visible while I was in another application) and I couldn't do it! At ALL!! I had to close it down from the bottom menu bar! MAJOR FAILURE! There's so much garbage up on the top that you've literally sacrificed usability for mostly useless abilities. Keeping the ability to "link" while dumping the ability to move the…

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                      Moving Excel using the top (green by default) bar is already supported, and works the same as it has in previous versions. If you can link to a video that shows the problem you’re having, we’ll be more than happy to take a look.

                      Cheers,
                      Dan [MS]

                    • Columns

                      At the moment the worksheet columns only have the corresponding letter at the top. If it were to somehow have the corresponding number equivalent many VB users would appreciate it.
                      How it could work - while mouse is hovering over the Letter "Z" would display a "26" and so on.

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        8 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

                        Hi,

                        This is already possible, using R1C1-style references. To enable them,

                        1. Go to File > Options > Formulas.
                        2. Under “Working with formulas”, check the “R1C1 reference style” check box

                        Hope that helps,
                        Dan [MS]

                      • Move command - the ability to select a row or column and insert it automitacally. If anyone remembers Visacalc or SuperCalc, they had this

                        Move command - the ability to select a row or column and insert it automitacaly. If anyone remembers Visacalc or SuperCalc, they had this

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

                          It is already supported to cut > paste, or drag-to-move a range of cells within a spreadhsheet.

                          Maybe a bit more detail would let us know if this is a new idea that you have!

                          Cheers,
                          Dan [MS]

                        • Functionality

                          Making this version as functional as previous versions. Can't use arrows keys to navigate between cells. Keyboard functionality is non-existent. I've gotta stop what I'm doing to use the mouse to navigate anywhere but to the cell below. WORTHLESS!! A VERY DISAPPOINTED USER!!! (Excel has always been my fav program. I even do my lesson plans in it rather than a word processor.)

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                            Excel 2016 allows the various keyboard functionality that you’ve mentioned. Please add more detail if there are items that you’re still running into.

                            Cheers,
                            Dan [MS]

                          • 1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                            • 1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

                                As long as you’re using functionality that exists in previous versions, macros should be backward compatible.

                                If you have a specific problem, please feel free to post it on UserVoice or on answers.microsoft.com.

                                Cheers,
                                Dan [MS]

                              • 1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                                • Bring back the Split Box

                                  You used to have a split box above/to the side of the scroll bars. This went in 2013 for some reason - there was no justification:
                                  https://support.office.com/en-us/article/Discontinued-features-and-changed-functionality-in-Excel-2013-c417e377-26c6-4f43-be6d-16718dd75ffa#__toc342560933

                                  Please can we have this back?

                                  9 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

                                    While the split control is no longer above the scroll bars, it is still available in Excel. To add it to your Ribbon or QAT, you can:

                                    1. Start Excel
                                    2. File > Options > Customize (QAT or Ribbon)
                                    3. Choose commands from “All Commands”
                                    4. Find the “Split Window” command
                                    5. Add it to your QAT (or to the ribbon).

                                    Hope that helps!

                                    Dan [MS]

                                  • Windows 10 does not allow me to place the commas on accounting values where i want to sometimes

                                    I must always be able to format giving me the commas after three places in accounting and currency format

                                    1 vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                                      You can use a custom number format to place the comma, if the built-in ones don’t work for you. If you’re having trouble even with custom formats, please upload a copy of the file that shows this issue, or list out the specific steps that reproduce the issue, so we can look into it.

                                      cheers,
                                      Dan [MS]

                                    • The F4 function key

                                      The F4 function key no longer insert the $ to lock in cell locations. Fix it.

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Allow Excel to create a back-up file exctly as WORD does.

                                        WORD actually saves a Back-up file to the directory you are using and it creates it every few minutes, or however you decided. EXCEL does not. It says it creates a back-up file but it rarely can be found and when it is found, it is not the most recent version.

                                        1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

                                          Excel does this as well. You can find the location of these backup files (and configure how often they are created) under File > Options > Save. There you will find the “AutoRecover file location” and other related settings.

                                          Cheers,
                                          Dan [MS]

                                        • 1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

                                            Hi,

                                            To use the same file on multiple computers, we’d suggest storing the file on OneDrive.com. Excel (on any computer, mobile device, or browser) can then access the file.

                                            To learn more, visit onedrive.com

                                            Cheers,
                                            Dan [MS]

                                          • Don't see your idea?

                                          Feedback and Knowledge Base