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. Python as an Excel scripting language

    Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))

    5,734 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

      391 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

      Wow.

      Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

      Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

      We’ll provide updates as we progress on this feature request.

      Thanks!

      Ashvini Sharma
      Lead Program Manager
      Excel

    • 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,909 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

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

        Hi all,

        I wanted to share with you that the new query caching mechanism in Excel has been deployed to Office Insiders starting from Excel version 1801 (build 9001.*). At this stage, we would like to allow some “baking” time as we monitor the feature health metrics.

        In this scope, we need your help to ensure a quality release! I encourage you to try the following scenarios and share your feedback:
        1. Run Refresh All on a complex workbook with multiple query dependencies. Does it work faster?

        2. Run Refresh All on a complex workbook with multiple query dependencies. Do you see any issues with your data?

        3. Refresh a single query several times. Do you see any issues with your data?

        - The Excel Team

      • Have Excel scroll better when there are large cells.

        If there's a really tall or wide cell, Excel jumps to the edge of the cell when scrolling past that area. This is a big pain when, for example:
        - trying to position a shape
        - Trying to grab the edge of the row or column in order to resize it.

        Excel should just scroll normally without jumping.

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

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

          Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

          Eric Patterson (Program Manager – MSFT)

        • Stop Excel from changing large "numbers" (actually text values) to scientific notation.

          Prevent Excel from changing large "numbers" (actually text values) to scientific notation.

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

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

            Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request.

            - Urmi [Msft]

          • Maintain leading zeroes when entering values in cells

            There should be an application setting OR paste recovery option OR cell format to retain leading zeroes when entering values in cells (either manually or through another means like CSV import).

            (2015-11-05 Dan [MS] Updated idea title and description to broaden this issue from maintaining leading zeros on CSV data import to maintaining them on any cell entry.)

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

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

              Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.

              - Urmi [Msft]

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

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

                Hi all,

                We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

                Thanks!
                Blake, Excel Product Team

              • Pull Current Stock Prices and Historical Data Into Excel

                Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.

                It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.

                864 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

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

                  Progress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*

                  We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs

                  Again, we genuinely appreciate your involvement as we…

                • Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

                  In the good versions of Excel (prior to 2007) one could open multiple workbooks in the same window. Now, one has multiple instances of Excel (and every other Office app) whenever one opens more than one document / spreadsheet. Quite stupid.

                  (2016-04-27 Dan [MS] - updated title to fix MDI/SDI usage - they were previously being used "backwards")

                  799 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

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

                    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

                    John, Excel

                  • Link the min and max values of a chart axis to cell value

                    It would be nice to be able to link the min and/or max value of an chart axis to a cell reference instead of manual enter the value or the auto function.

                    789 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                    • Make Undo stacks track per workbook instead of globally

                      Undo stacks are currently global between all workbooks that are open at a given time, so pressing undo on one workbook might undo a change in a different workbook. As someone who frequently has multiple workbooks open at a time, it would be much more helpful to be able to step through the edits made on each individual workbook.

                      749 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

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

                        Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

                        John, Excel

                      • Make a simple safer version of VLOOKUP and INDEX MATCH

                        The majority of Excel users use VLOOKUP to get exact matches from a row or column, It would be good if they all used INDEX MATCH but it's more complex so how about this simpler version for the masses.

                        =GETMATCH(ReferenceToMatch, MatchColumn/Row, GetColumn/Row, Optional Value if no match)

                        If seen a few other references to updating VLOOKUPS and there are lots of opportunities, but it would be good to address the simple most widely used issue first.

                        650 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

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

                          Thanks for the suggestion Wyn! Thanks also to all the contributors to this thread for the thoughtful discussion and debate.

                          Of the many lookup function requests, this is currently one of the highest ranking on UserVoice. Please keep the votes rolling in if you’d like to see this, it helps us prioritize new feature work.

                          JoeMcD [MS XL]

                        • Get Tables working on protected sheets (add rows, sort, filter, etc.)

                          I would like to be able to, under the right circumstances, have the ability to add/remove rows of a table which resides on a protected sheet.

                          Currently if you protect a sheet you can't insert/delete rows of a table. Even if you unprotect all cells and allow inserting/deleting of rows on sheet protection, it doesn't matter and is completely ignored.

                          What I am proposing would have to follow specific rules:

                          * Table cells would have to be unprotected
                          * Cells below table would have to be unprotected (truly optional † )
                          * Insert Rows would have to be specified in…

                          610 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

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

                            Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

                            Thanks

                            Ashvini Sharma
                            Lead Program Manager
                            Excel

                          • Give us a proper NULL() worksheet function.

                            This would make calculations and charts treat a cell containing a formula as a blank cell, not as a cell with a text string ("") or as a zero.

                            567 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

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

                              Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

                              Thanks,
                              John [MS XL]

                            • Make Power Pivot available in all versions of Excel

                              Previous title: "Make the Power BI Family - PowerPIvot + PowerQuery + PowerView and PowerMap available in all versions of Excel".

                              500 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

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

                                Hi all,

                                I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.

                                We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.

                                Thank you for pushing for this!

                                Ashvini Sharma
                                PM Manager
                                Excel

                              • Conditional formatting - Apply to named ranges

                                Currently if you apply conditional formatting to a named range (i.e.. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Condidtional Formatting Rules Manger will revert the named range to its absolute cell reference.

                                eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".

                                Apart from being more difficult to read, it creates other complexities. e.g. if I happen to copy/paste a cell into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.

                                e.g. if my named range is 'Table1[Column3]' which…

                                495 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

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

                                  Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

                                  Thanks,
                                  Steve (MS Excel)

                                • Visually show which cells are selected even when another application has focus

                                  Currently, when I select one or more cells and then switch to another application, the boundary box and shading for the selected cells are not shown. Other Office applications exhibit this behavior as well--selection highlighting is only displayed when the program has focus. Many (most?) non-Office applications show the highlighting at all times.

                                  It would be far more useful to be able to glance at the spreadsheet and see which cells are selected, even when working in another program.

                                  411 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

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

                                    Great suggestion E Bow. Thanks for taking the time to tell us about changes you’d like to see – we’re listening. We’ll take a look at this one. As always, folks should keep voting for the things they like the most – we’ll generally be prioritizing things according to the number of votes they get.

                                    Cheers,
                                    John [MS XL]

                                  • Enable user to pin Folders to the recent lists for Open and Save As

                                    ** Please bring back functionality from the old Microsoft Office suites (not just xls).

                                    ** For alphabetic sorting of files in the recent lists, please don't vote here. Instead, see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10261443-recent-files-pane-in-excel-2013-was-pretty-good-b

                                    Specifically: it is useful to have a list of recently-accessed folders from which to open files. Such folders were available on the older versions of Microsoft (MS) Office, but not in the 2016 “upgrade”. (i.e. MS Office 2016 contains only a list of the recently opened files.)

                                    Constantly having to navigating BACK to a recently used folder to open / save a file is very annoying.

                                    I'm not the…

                                    409 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

                                      48 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Number format thousand separator and no decimals

                                      Every time (many days a year) I train people in Excel, someone ask why there is no button or shortcut to obtain a number format with "thousand separator and no decimals". At least - in northern Europe - this is the most common used number format. If "button-solution" not possible for Microsoft in order to have common buttons world-wide, at least a shortcut for this has been much appreciated. (Note that the current button for thousand separator and two decimals could not be used, though the alignment in that format are not disired/good and two decimals used).
                                      Today I teach…

                                      395 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

                                        95 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Add ability to collapse field areas in PivotTable Field and Area Side by Side view

                                        With the ability/normal experience of creating many DAX measures in Power Pivot, the Values area of the PivotTable design is now too small to use effectively. Since the Values area only shows about 4 rows it's really difficult to organize fields correctly when try to drag fields around if you've got 10 or more fields in your Values area. (not at all uncommon for Power Pivot users, although certainly not restricted to them.)

                                        With the introduction of slicers, however, we also tend to use the Report Filter area less, and don't usually add as many fields to the row/column areas.

                                        364 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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                                          Hi Ken,

                                          Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

                                          thanks
                                          ash [MS XL]

                                        • Built-in RegEx / Regular Expressions Functions to Search, Extract, and Replace

                                          I've constantly found myself installing and re-installing add-ins that add RegEx Functions to Excel. Everyone I introduce them too finds them extremely useful. There's over half a million results in google for the query ["excel" ("regular expression" OR "regex")].

                                          342 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 276 277
                                          • Don't see your idea?

                                          Feedback and Knowledge Base