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,964 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

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

      Hi folks –

      Thanks for the continued passion around this topic.

      We’d like to gather more information to help us better understand the needs around Excel and Python integration.

      To help us with this, can you please complete the survey below?

      https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR7tUuWqOwSJFpBE5ZLhdkgtUMkhZWlkxRjhDRklXSjNTVkNSWkE2WlNQMS4u

      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,307 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

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

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

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

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

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

            863 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

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

              503 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

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

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

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

                  • 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

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

                      433 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  ·  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…

                        331 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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
                        • 328 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

                            159 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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!

                            316 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

                              started  ·  9 comments  ·  Editing  ·  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.

                              312 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  ·  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]

                              • 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()?…

                                301 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

                                  54 comments  ·  Editing  ·  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.

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

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

                                    268 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

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

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

                                      253 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

                                        49 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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.

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

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

                                          236 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

                                            19 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 174 175
                                          • Don't see your idea?

                                          Feedback and Knowledge Base