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

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

      • 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

        • 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 →
          • 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 →
            • 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…

              • Unselecting cells when using Ctrl to select multiple cells

                When using Ctrl to select multiple cells, we can't unselect a cell when it was misclicked. Instead, we have to click these cells all over again. Please allow us to unselect cells!

                327 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

                  16 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                • Support saving CSV in UTF-8 encoding

                  Currently, if I create a CSV file with Excel, it can only be saved in ANSI format, turning all special characters to garbage. I would like to be able to save it in UTF-8.

                  I know I can save it in the "unicode text" format, but the problems with that are:
                  1) It uses tabs instead of comma.
                  2) The encoding is not UTF-8, making it alien to other applications.

                  250 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

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

                    2016-11-01——————-

                    Great news here folks – we’ve completed our work on this feature and Excel will support a new CSV format using UTF-8 encoding.

                    This fix still needs to make it through our release pipeline, but you should see it as an option once you have a build equal to or later than 16.0.7466.2023.

                    Cheers,
                    Dan [MS]

                    2016-06-28———————-
                    Good news – we’ve started work on this.
                    Cheers,
                    Dan [MS]


                    older——————-
                    Thanks for the suggestion Doron. As Dan mentioned in the comments, we’re watching this one. I’ve seen a number of other suggestions related to CSVs as well. We’ll keep our eyes open here and take a look at the highly voted things in this space. As always, keep the votes coming to help us do a good job prioritizing your favorite asks to the top.
                    Cheers,
                    John [MS XL]

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

                    • Recent Files pane in Excel 2013 was pretty good, but Excel 2016 broke it (Pin pinning recent files no longer sorts alphabetically)

                      In Excel 2013, you could pin recently opened files to the top of the list, and they would be sorted alphabetically. This way, you could easily get the same file by using keyboard shortcuts. For example, Alt-F-R-1 opened the first one on the list, alphabetically. The order stayed constant until you pinned or unpinned a file.

                      In Excel 2016, the files are listed chronologically, so Alt-F-R-1 opened the most recently used one. If you wanted to get a certain one, you have to wait to see where it is in the list. This is a TERRIBLE change. I keep opening…

                      221 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

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

                        = 2016-12-09 =
                        Hi all,

                        The MRU should be sorting alphabetically again if you’re using build 16.0.7466.2038 or later. You can find your build number under File > Account.

                        Cheers,
                        Dan [MS]

                        = 2016-09-22 =
                        Hello,

                        I noticed a few reports of folks not seeing alphabetized MRUs anymore so I followed up with the Office team (it’s shared across Word, Excel, PowerPoint, etc.) that owns this.

                        Turns out that they rolled it out in July (and then we posted here that the work was completed) but then ran into some bugs and so disabled the feature on the MRU-service side.

                        That bug has been fixed, and they are planning to roll it out again in October.

                        Cheers,
                        Dan [MS]

                        = 2016-07-11 =
                        Greetings,

                        Good news on the recent files front – pinned files are now sorted alphabetically, as they were in previous versions of Office (and Excel).

                        To see…

                      • let pen usage toggle between inking and pointer

                        The January 2016 Office update defaults the Surface Pen to an inking tool. Most Excel users prefer to use the pen as a pointer. Please give us a toggle in the ribbon to switch between inking and pointing.

                        155 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

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

                          (2016-03-15 – Completed) (Edit: Added link to Office Insider signup)

                          I wanted to let everyone know that in the update to Office that started rolling out to Insiders today, you will find a new preference in the Options dialog to allow you to make the pen select instead of ink by default. Enabling this preference will make the pen function exactly like it did before, plus you can use the options on the Draw tab if you do decide you want to ink. If you are an Office Insider (which anyone can join – https://products.office.com/en-us/office-insider), you should get this update within the next day or so. If you are not an Office Insider, it may take another week or two to reach you.

                          This is a per-app preference, so you can enable selection by default in Excel for instance while leaving ink as the default in Word and PowerPoint,…

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

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

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

                              • Improve the Concatenate Function

                                Make Concatenate to Work with Range of Cells / Arrays rather than 1 cell separated by Comas

                                =CONCATENATE(Array,Seperator)
                                The Array to Accept A1:A10 or A1:D1 or {"Abb","Areva","BHEL"} or {"ABB";"Areva";"BHEL}
                                or

                                70 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

                                  19 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                • Histogram, box plot, quantile plot, and other statistician-friendly features needed

                                  I am regularly surprised when Excel can do complex operations using built in functions, but there is a lack of data visualization options out there. For example, a histogram, box plot, and quantile plot can provide options for visualizing and comparing data. I know these can be achieved using various add-ins (for example QI Macros), but those are never perfect and always seem hokey. Also would love to be able to do hypothesis tests (t-test, f-test, z-test, and so on) in user friendly and visual manner. Also, for all charts, please add a feature for using split column(s) to differentiate…

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

                                    In Office 2016, we released 6 new built in chart types: Treemap, Sunburst, Histogram, Pareto, Box & Whisker, and Waterfall. Checkout the following link for the top new features in Excel 2016. https://docs.com/ExcelDemos/7981/excel-2016-top-features.

                                    However, there are several other feature requests wrapped up in this post. Please enter those as separate items so that we can respond to them individually.

                                    Thanks,
                                    Scott [MSFT]

                                  • Please add MAXIF and MINIF

                                    It would just be so useful to have this. Thanks!

                                    40 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

                                      14 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

                                      2016-04-19

                                      Hello all,

                                      Just wanted to let you know that we’ve released MAXIFS and MINIFS to Excel as part of Office 365. If you’re a subscriber you should already have (or see soon) these functions in your arsenal.

                                      Cheers,
                                      Dan [MS]

                                      2015-11 ========
                                      Hi there,

                                      Great news – we’re working on this! Actually, we’re working on MAXIFS and MINIFS – even better :-)

                                      Cheers,
                                      Dan [MS]

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

                                      • Kindly make power pivot option as a standard in excel 2016

                                        The use of pivot has increased over the period of time. Currently power pivot is provided as add-in and is not part of standard excel. Request you to make power pivot as a standard option in next release of excel i.e. Excel 2016

                                        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

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

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

                                          Feedback and Knowledge Base