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. Bring back Edit Comments (Legacy) to the Right-Click Menu

    The new Threaded Comments that appeared in Build 1809 are awesome for 99% of the people. But for the Commenting Gurus - anyone who has ever taken the time to build help systems by resizing, re-coloring, re-shaping and using Show All Comments, we are going to see our comments get destroyed by well-meaning co-workers.

    Yes, all of the legacy icons are available for adding back to the Ribbon, but we the comment gurus can not trust our co-workers and managers to take the time to add these.

    My request: If Excel detects any comment in the workbook that is a…

    153 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

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

      We have addressed the topic of this suggestion by bringing back the legacy comments as notes and included the edit comment action as “edit note” in the right click menu. Also, this topic has multiple suggestions, so if for any remaining suggestions which are not covered by the update to reintroduce legacy comment editing, please open a new suggestion. Thank you.

    • May 2017 update which keeps the copied item active in the clipboard

      Regarding the issue of...It's part of the May 2017 update which keeps the copied item active in the clipboard even if you do things that would normally clear it, like typing in a cell, applying formatting, etc.

      Pressing ESC will clear the marquee/dancing ants.

      Why in the world would Microsoft and an extra step here. This is terrible. At least give us the option to turn off the function. Please change this back or give us the option. Very disappointed!

      586 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

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

        Keep the Copy was designed to improve the experience of copying content to your clipboard based on customer requests. Copy and Paste functionality is different in Excel than most other applications because results from formulas can change and due to the large size of worksheets. Since making the improvements there has been mixed feedback about the changes that we made and it is not up to our quality standards. Effective today, Keep the Copy will be removed from Excel until we have improved the quality and design of this feature.

        Thanks,
        Eric Patterson
        Excel Program Manager

      • Power Query - cache shared nodes

        Update Power Query in Excel to take advantage of caching in cases where a parent node refers to a child node that has already been refreshed (as exists in Power BI desktop today).

        This issue creates significant performance problems with refresh times when creating highly interdependent financial and operational models. This is a show stopper from a usability and customer acceptance standpoint.

        1,977 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

          293 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

          Hi all,

          We are happy to announce that the feature is finally available on Production starting from July fork (build 16.0.10726.*) for Office 365 subscribers.

          Thank you all for your votes and the feedback.

          - Excel Team

        • AutoSave Master Switch rather than an "I Told YOu So!" later

          Microsoft has added a new feature to help users co-author files. Whether you are for or against this feature is not my point here: it needs Excel's AutoSave switched on to work. That's fine. But it shouldn't be the default. It is accepted that Office is trying to make various apps consistent, but Excel is used differently. What makes it the most popular software in the world is the ability to experiment without consequences.

          Made a mistake? No fear, close without saving and re-open. Accidentally delete a sheet? Don't worry, close without saving and re-open. Replaced all formulae with =RAND()?…

          353 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

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

            We have been listening to your feedback and are updating AutoSave with the ability to turn AutoSave off if desired. There are three patterns in this feedback thread that we are addressing now. The first pattern is that you want AutoSave off because you make temporary edits or hypothetical edits that you don’t want to save (we call this what-if analysis). The second pattern is that you start a new file from an existing file after making some changes to the existing file (like a Template or Invoice). The third is that sometimes the “Last Modified” timestamps are changing even when no edits were made.

            In response to the feedback about a desire for AutoSave to be off by default due to temporary or hypothetical edits (what-if), we have added some new functionality and options for AutoSave:
            1. You can turn AutoSave off for a specific file. While a document…

          • removing sexist algorithms

            Please can you allow "Mrs. and Mr." to be written in excel without excel autocorrecting to "Mrs. And Mr." because the traditional rules state that the man is first. I am writing letters to donors and I always put the donor in the first position and the associated donor in the second. Excel only auto capitalizes the "and" when it is in the Mrs. and Mr. position. This is a pain that it was written into the algorithm. And sexist. Thanks.

            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

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

              We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “Mrs. and Mr.” into cell A1, Excel will autocorrect it to “Mrs. And Mr.”. If you go back and type “and” again in the same place, Excel will not correct it again. It will still autocorrect “Mrs. And” if you type it into a different location, or if another autocorrection happens before you change “And” back to “and”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

              This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

            • Make Excel obey the "scroll inactive windows" setting in Windows 10

              Make Excel obey the "scroll inactive windows" setting in Windows 10. Currently Excel will scroll when it is an inactive window, but it will not allow other windows to scroll when it is the active window. This makes transcribing data from a source that needs to be scrolled difficult.

              97 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

                62 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                Thanx for creating and voting on this folks!

                You should see this issue fixed starting with the latest Windows 10 Preview 17133.73 build update on 4/10 (https://blogs.windows.com/windowsexperience/2018/03/27/announcing-windows-10-insider-preview-build-17133-for-fast/) as well as latest Excel Monthly channel 1803 Build 9126.2152 update on 4/11 (https://technet.microsoft.com/en-us/office/mt465751.aspx).

                Please let us know if you find this still not fixed with these builds (and later).

                thanx,
                Prash [MSFT]

              • No more warnings about saving as CSV, especially when I didn't change anything

                I don't know how many hundreds (thousands?) of times I've told Excel that, yes, I really truly do mean to save this file as a CSV. I recognize that not all users will understand that CSV doesn't do cool formulas or formatting, etc., but I do and I still want to do it. And I want to do it a lot. Please, give me a way to opt out of these useless warnings!

                1,196 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

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

                  2016-09-07

                  We’re done – you should no longer get a warning dialog about data loss when saving a file as CSV, as long as the file was originally opened as a CSV file.

                  Instead, we’ve added a non-intrusive business bar (that you can ignore if you choose) that let’s you quickly Save As the file if you have made changes that are not savable in CSV; if you ignore it and just Save, we’ll just save out the CSV values as you’d expect.

                  We actually rolled this out starting on August 13, 2016 with build 16.0.7167.2040 for O365 users. Later builds have this update as well of course.

                  Thanks for participating in UserVoice – we definitely value your input. You can now use whatever votes you’d allocated for this idea for other ideas.

                  Cheers,
                  Dan [MS]

                  = started status 2016-06-15 =

                  Great news – we’re working on this…

                • make excel 2016 as stable as previous versions

                  Make Excel 2016 as stable as previous versions
                  We run complex spreadsheets with conditional formatting and links between spreadsheets and macros to drive behavior - this is both inherently slow (on various different computers) and unstable - crashes almost daily
                  Previous versions of Excel handled these same spreadsheets cleanly and easily !!!

                  104 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

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

                    Thank you all who voted! And we hear you loud and clear and we have been working hard at improving Excel 2016 stability on-going with every monthly release with our January monthly channel release at historically low levels based on our internal measures.

                    Moving forward, please send us feedback from within Excel, which includes actionable crash information we monitor regularly. Once Excel reboots from a crash please goto File → Feedback → Send a Frown, provide information on what Excel specific action you were doing when the crash occurred and press the “Submit” button.

                    thanx,
                    Prash [MSFT]

                  • Allow users to set/choose defaults (via settings) for PivotTables - Layout (compact, tabular, classic, etc.), PT Options, etc.

                    Excel 2007 introduced the new Compact Form and made it be the default for all future pivot tables. With this layout, multiple row fields are compressed into column 1 of the pivot table. This makes the data very difficult to later re-use.

                    My request is to add a setting in Excel Options where each person can choose their default pivot table layout. All future pivot tables will use Tabular, Outline, Compact, or Flat. (Flat is a new layout introduced by Power Pivot... it is Tabular with no Subtotals).

                    Additionally, the same settings area shouls allow the user to save other…

                    560 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

                      77 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                    • Disable time grouping

                      The new automatic time grouping in PivotTables should be an option within Excel. Users should not need to make a registry edit to disable this feature, and the time grouping should not be on by default.

                      10 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

                        73 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                        Hi all,

                        This ability to turn off time grouping from the UI was recently added to the O365 version of Excel. File→Options→Advanced→Data→“Disable automatic grouping of Data/Time columns in PivotTables”.

                        We’re considering adding this back to the perpetual release of Office 16. Until that’s available, you can also turn it off manually using the registry, outlined in this article: https://support.office.com/en-us/article/Turn-off-time-grouping-in-PivotTables-in-Excel-2016-for-Windows-6be5afed-348c-4db2-9f87-5ac262d67b3f.

                        Regards
                        Ashvini Sharma [MS]

                      • Maintain copied data on the clipboard even if the "dancing ants" aren't shown around the copied range (Copy-paste clipboard persistence)

                        If I copy [ctrl-c] a cell, then type in another cell, then try pasting, no result. No paste. It would be nice if Excel would maintain the copied data on the clipboard even after the dancing ants no longer appeared, so that I could paste that data.

                        (2015-11-05 Dan [MS] - updated idea title and description to be clearer)

                        224 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

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

                          Starting with the Excel release available in June, Excel “Keeps” your copy longer. You can Copy your cells, and before you paste, you can still do other tasks like typing or inserting cells.

                          Based on customer feedback, the dotted “Marquee” stay active for much longer so that you can type, add formatting or many other things before the paste operation. We also made both the “Insert” and “Insert Copied Cells” commands available after the copy operation. Now, if you are copying data to another worksheet, only to realize you need more room, you can insert a variable number of cells and then paste without having to re-copy the original range!

                          If you want the Marquee to disappear, you can use the ENTER key to perform the paste operation, or after the paste, you can press the ESC key to cancel the copy.

                        • Add icons for font superscript and subscript so we can put them on the QAT

                          Word has direct access (with icons) on the ribbon for subscripting and superscripting characters, but Excel can do so only via the Home...Font menu item. Scientists and engineers need to use subscript and superscript characters when writing mathematical and chemical formulas. Please copy the subscript and superscript icons in Word, and make them available to the Customize QAT feature.

                          371 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

                            73 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                          • Excel 2016 crashes with large sheets and filtering

                            When opening a large file and start filtering, work with that filter, use a second filter dn remove one of the filters Excel crashes

                            6 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

                              75 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

                              Hi all, the original issue reported in this thread was due to Win10 changes in Accessibility. The fixes for this have been released for Excel 2013, Excel 2016 and Office 365 subscribers in March.

                              For more information, this thread has the discussion: http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-filtering-problemmatic-after-windows-10/f6f34982-d4e0-47b3-bd37-772fd51e0ff3.

                              thanks
                              ash

                              Ashvini Sharma [MS]
                              Excel

                            • Allow Charts to use data from hidden cells

                              As of now, if you group and/or hide cells that contain data going to a visualization, the visualization goes blank. I'd like to be able to hide data without losing the corresponding visual.

                              5 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

                                We actually support this feature in versions of Excel back to XL 2007. Here are the steps.

                                1) Select the chart
                                2) from the chart “Design” tab in the ribbon click on the button “Select Data”
                                3) In the dialog, click on the button called “Hidden and Empty Cells”
                                4) In the dialog, check the box called “Show data in hidden rows and columns”

                                Thanks,
                                Scott [MSFT]

                              • Don't autocorrect if you can't override (idiotic functionality keeps changing EHR to HER, but you can't undo like in Word or Outlook).

                                Get smart like iOS on your autocorrect. If you a user deletes/overrides your autocorrection right away, leave it alone. The way the feature is implemented in Excel leaves the user no choice but to turn it off.

                                Try it. Type EHR (as in Electronic Health Record) into a cell (with our without the leading single quote and watch it autocorrect to HER when you hit return or select another cell. Undo does not work (like it does in Word or Outlook).

                                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 →

                                  We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

                                  This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

                                • Stop Auto correcting certain words

                                  Just as in Word when you type: i.e ihs, it will auto correct to "his" but it will place a little grey bar under that word that has a pull down menu allowing an option "Stop automatically correcting this word." Excel does not have that feature, must enter auto correct menu and use the exception menu to place it on the list. Change Excel to have same options as Word.

                                  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

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

                                    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been greatly improved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

                                    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you…

                                  • stupid speling correction

                                    hey hey hey ! what is this ! i am trying to type a name list (teh) excel change back (the) and keep changing and changing u think u fking god know what i want is it ! i HAVE NO TIME FOR TIS ****.

                                    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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

                                      We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

                                      This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

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

                                        1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                                        Update (July 25)

                                        Hi again Erik,

                                        This issues should be fixed in our August 2nd update.

                                        If it isn’t, pls reach out to me directly at myfirstname dot mylastname at microsoft dot com.

                                        Thanks again for raising it.
                                        ash

                                        Program Manager
                                        Excel

                                        Hi Erik,

                                        Boy, you’ve been having quite a saga here. Even though this site is for new requests, appreciate finding out about this. I’m reaching out to Brian to understand what’s happening so far.

                                        thanks
                                        ash [Microsoft Excel]

                                      • Found an error in Excel 2016 help documentation

                                        The results column in the help window for the index function just mirrors the formula. Looks like it's because there's an apostrophe before the formula. Not sure where to report this. Looks like it's the same for 2013 too.

                                        Screen shot can be found here: http://answers.microsoft.com/en-us/office/forum/office_2016-excel/found-an-error-in-excel-2016-help-documentation/410a27a3-0b3b-41c7-a99c-8fc2ff323542?tm=1472245876517

                                        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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

                                          Thanks for the heads up. We’ve updated the topic, so the changes should go through shortly.

                                          (And thanks Smitty for making the update!)

                                          Cheers,
                                          Dan [MS]

                                        • HTML formatted files (with an XLS extension) no longer opened

                                          Since a recent update HTML formatted files with .xls extension are no longer opened. When downloading such a file Excel opens but does not open the file anymore, it just shows a blank screen, no error message. This used to work for years and was very easy to create reports from our intranet by just sending HTML files with Excel headers out. Because of this we now have to re-engineer all reports, please bring the functionality back.

                                          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

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

                                            Hi all,

                                            We’ve released a fix for this issue. I’m copying the official release notes for it here, as this is part of several different updates to several different versions of Office:


                                            The Excel team has released a change in behavior in today’s security update for Excel 2010, 2013, and 2016. Excel will warn about the mismatch between the file extension and HTML content, but will now open the workbook in Protected View as an additional layer of security. If you trust the workbook, you can then enable editing. The behavior of .xla and .xlam files will remain the same.

                                            How do I get the update? It depends on which version of Office you have.
                                            • Office 365 subscription (Click-to-Run)—install the latest updates
                                            • Windows Installer version (MSI)—you could wait about a week for the next security update for MSI, and it will update automatically. Or, to…

                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base