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. Allow me to format with "" and insert /n

    Can you allow me to format text with "" Example "John Doe" Also, can you create button that inserts a \n where I need 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

      Hi George,

      You can already format text with quotes (but maybe I’m misunderstanding what type of formatting you’d like to see – please clarify).

      For inserting a new line, you can press Alt+Enter

      Cheers,
      Dan [MS]

    • paste as text

      excel is missing one important function: PASTE AS TEXT...

      for various reasons pasting with excel intelligent guessing the type of data in the pasted cells do not work well, although there is no error in that (doing unexpected conversions of pasted data)...

      what I need is the functionality to say to excel: paste all data as text into appropriate cells (and I will later edit it and correct and convert data)

      also, convert-text-to-columns should have that functionality... yes, I am aware that I can use that functionality at the column level, but I would also like to be able to…

      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 →

        This is already supported, if I understand what you’re looking for. Look for Paste Special > Values (if you copied from Excel) or Paste as Text (if you copied from another app).

        Cheers,
        Dan [MS]

      • 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]

              • 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]

                                          • Don't see your idea?

                                          Feedback and Knowledge Base