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.

Take a look at the feedback that we are currently working on and what feedback we have already completed.

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

    3,133 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

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

      HI folks,

      Thanks for the continued passion around this.

      We’ve been busy building an infrastructure that allows remote execution of arbitrary code from custom functions in Excel. This was introduced last week at the Microsoft Ignite conference with Azure Machine Learning (https://azure.microsoft.com/en-us/blog/tools-for-the-ai-driven-digital-transformation/), which itself can host code in various runtimes.

      This is just the beginning, and doesn’t cover many of the scenarios this user voice item now has. Just wanted to drop a quick note saying we’re continuing to work to deliver the scenario we announced with high quality and explore other integration points.

      Thanks again

      Ashvini Sharma,
      Lead Program Manager
      Microsoft 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,116 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        113 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
      • Stop Excel from changing large "numbers" (actually text values) to scientific notation.

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

        747 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

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

          Thanks for the post Caleb. As some folks in the comments mention, you can change the format of the cell to Text before the paste. But even so, it’s clear that there’s some user pain around this experience. We hear you and we’ll evaluate how we can do a better job here. As always, we’ll spend the most time/attention on the things with the most votes, so please keep voting for things you want the most.

          Best,
          John [MS XL]

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

          550 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

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

            Thanks for the post – and thanks to all those that are speaking with their votes – we’re listening. I’ll get someone on the team to take a look at this. As always, keep voting for things that matter to you – the things with the most votes will tend to get prioritized higher on our side.

            Thanks,
            John [MS XL]

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

            491 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

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

              Thanks for the suggestion Oz! I personally couldn’t agree more. As Dan mentioned in the comments, we’ve got a bunch of other Excel endpoints behaving this way already, and this is on our longer term roadmap. We’ll evaluate excelerating (that’s my pun for the day) getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

              Best,
              John [MS XL]

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

              452 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                87 comments  ·  Formulas and Functions  ·  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.

                420 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  33 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                • 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.

                  416 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

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

                    Thanks for this suggestion! We are evaluating this for a possible future release. Please continue to vote on this idea.

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

                    402 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

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

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

                      314 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        33 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
                      • 308 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          153 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • 302 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            342 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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.

                            279 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

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

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

                              271 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

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

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

                                263 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

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

                                  Thanks for the suggestion. We generally try to prioritize things according to the number of votes they get – so please be sure to vote for things you want to see done sooner.

                                  Thanks,
                                  John [MS XL]

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

                                  231 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    81 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)

                                  • VLOOKUP function for multiple criteria

                                    There should be a *VLOOKUPS function (or you name it) alongside VLOOKUP to find data based on multiple criteria. I know there are workarounds like INDEX and MATCH but they are unnecessarily complicated considering COUNTIFS and SUMIFS functions do a neat job at counting and adding multiple criteria. And please make it so it works with unsorted data.

                                    226 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

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

                                      Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

                                      Best,
                                      John [MS XL]

                                    • Enable collaboration with others editting in Excel desktop

                                      In Word and PowerPoint you can collaborate from the desktop as well as online. In excel, whenever anyone opens the document on desktop others get locked out of editing and can only view. This is a problem for our organisation since occasionally remote team members need to edit the file on desktop but failure to close down the document properly (either accidentally or because the OS somehow did not release the file lock which has happened on Mac's) means the entire team is suddenly unable to work for extended periods until we track down the culprit.

                                      225 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

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

                                        = 2017-03-28 =

                                        Hi all,

                                        Great news – as of today, we’ve released co-authoring in Excel for Windows Desktop to anyone who is in the Insiders Fast group. If you’re an O365 subscriber, you can get yourself into that group by going to http://office.com/insider

                                        Once you are an Insider (Fast), you can co-author on files stored in OneDrive, OneDrive for Business, or SharePoint Online, with anyone editing in Excel Online, or Excel on mobile (Android, Windows, and iOS).

                                        We’d love to hear how it goes, and we encourage you to invite anyone you work with to also update to Insiders Fast (so that you can co-author with them).

                                        You can read more at https://blogs.office.com/2017/03/28/new-office-365-march-co-authoring-excel/

                                        Cheers,
                                        Dan [MS]

                                        = older =
                                        Hi folks,
                                        As Guy mentioned, we are working on this now. It’s a lot of work, so it’s not going to be done super-quick, but rest assured that this is…

                                      • 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")].

                                        220 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          18 comments  ·  Formulas and Functions  ·  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()?…

                                          204 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            36 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 155 156
                                          • Don't see your idea?

                                          Feedback and Knowledge Base