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

    Have a Control with the most recent filters (last 5 to 10 filters), so the filters can be reapplied to an existing table.

    This should enable power users to work faster and Archive more in Excel.

    18 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

      0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    • Allow interaction with Excel while in Power Query

      Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.

      The current behaviour makes it very difficult to do things like the following:
      -Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
      -When we have a static table in Excel and are trying to build a query that lands an…

      8 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

        0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
      • 11 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

          0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
        • Open multiple spreadsheets/workbooks within one instance of Excel 2016.

          Why was this discontinued? I hate that every workbook I open is now in its own instance of Excel. Such a waste of space and performance. Please bring this feature back!

          34 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

            11 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
          • update VBA

            It would have a couple of stages.
            Stage 1: Get Visual Studio features into the VBA development environment.
            Stage 2: Fully integrate VBA into Visual Studio.
            Stage 3: Continually improve VBA until it is a modern language.

            Notes:
            VBA is probably the most used programming language in the world.
            It has so many established users that MS could really get big brownie points by continually improving the experience for users and developers. Why it has stagnated for so long I have never understood.

            I have seen your response for the above posted previously and you are missing a major point.…

            11 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

              0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
            • OR function within the SUMIFS function

              I would love to have OR function within the SUMIFS function so if it meet either of two (or more) criterias it will be true.

              10 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

                3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
              • NULL Worksheet Function

                This request is to add a new function, =NULL(), which returns "blank" or null, forcing the cell to act as if it truly is empty; not a cell with an empty text string "" or 0.

                78 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

                  22 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                • Real-Time Co-Authoring for Excel Desktop

                  Hi,

                  Could you please give us an update on when Real-Time Co-Authoring for Excel Desktop will be available?

                  There are many businesses who have been patiently waiting for this for years.

                  The feature work brilliantly on Word, so we know you have the ability to do a great job of it!

                  I know it is available on Excel Online, but this can be slow and cumbersome - and not really suitable for many of the larger and more complex spreadsheets that we use.

                  Any update on the progress, or an ETA on when it will be available will be much…

                  15 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

                    2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                  • vba userforms

                    Please provide more controls on forms to improve its look and feel. 3D effects, animations on buttons, table formatting in text boxes, etc

                    6 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

                      2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                    • Put the color back in the Quick Access icons. The 2016 icon are impossible to decipher.

                      Put the color back in the Quick Access icons. The 2016 icon are impossible to decipher. The white theme is too bright. Please fix this awful problem. I am an accountant and I must use Excel desktop due to the size of my files. Your GIANT step backwards in icons is incomprehensible. Please give us a theme with the 2010 Excel colors and excellent definition.

                      20 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

                        5 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
                      • formula

                        Hi! I would like, if possible, to request a direct contact with one of the people of the development team of Microsoft Excel to explain an error that I found in the programming of an Excel formula.
                        This error generates results that are not real mathematically, nor logically.
                        I await a response and contact.
                        Greetings.

                        1 vote
                        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

                          2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                        • Put CHANGE CASE in Excel! Please!

                          Put CHANGE CASE in Excel! Please!

                          5 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                          • Enable Headers and Footers to include variables based on a cell reference

                            It would be great if a cell reference could be used within a header and/or footer

                            7 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

                              0 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
                            • Sub tabs

                              Having numerous tabs can be very messy and difficult to navigate through. It would be nice to be able to group similar / like tabs together. These tabs would be visible only when the main tab is selected. Attached is a sample of what I would be happy with.

                              3 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

                                0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
                              • Remove the pointless message “There's a problem with the clipboard, but you can still paste your content within this workbook."

                                The message shows up if you run in the background a program that keeps a peek into the clipboard, as for example the "Skype web plugin" and other telephone programs. A possible cause can also be the software "Audials".

                                You can find a thread with lots of complaints and a few flimsy justifications and non-answers here:
                                https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/clipboard-problem-in-excel-2016/224b2a59-8a0c-4897-baba-a481dd06e085

                                The message shows up with Ctrl+C, Ctrl+X, using the Format Painter and only taking whole cells. It does not show up if you copy a part of a cell content.

                                Contrary to some Microsoft officials’ posts, the error message shows up multiple times…

                                6 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

                                  2 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                • Amazon Redshift Connector

                                  Creation of an Amazon Redshift Connector for Power Query that is similar to Power BI.

                                  https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-redshift/

                                  6 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

                                    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Vlookup returns 0 when looked up cell is blank

                                    could you provide that if the cell to be returned in a vlookup or hlookup formula is blank, then the value of the formula also resolves as blank - or have this as a choice, e.g. Vlookup(c1,A1:b5,2,false,"") where "" = the value to be returned if the looked up cell is empty. The default could remain 0 if this is omitted from the formula.

                                    5 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

                                      4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Universal IF statement - to meet needs of IFNULL, IFBLANK, IFZERO etc.

                                      Are you tired of duplicating complicated formulas within an IF statement in order manage blanks or zeros?

                                      e.g. IF(long formula="","",long formula)

                                      A universal IF statement (lets call it IFX) would decrease this type of duplication without having to add multiple new IF formulas the likes of IFNULL, IFBLANK or IFZERO.

                                      An IFX function would accept the condition you want to test the formula against, if the condition is true it would return the specified alternative (such as blank). If the condition is false it would return the value of the formula itself. Ideally it would be able to accept multiple…

                                      3 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

                                        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Add "YYYYMMDD" to text that DateValue() can convert to a date

                                        A lot of systems keep dates in YYYYMMDD format and when extracting text, it would be nice to wrap that in a DateValue() function to convert to date. Fortunately Date.FromText() in PowerQuery/M Language does this, but =DATEVALUE() should too.

                                        6 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

                                          2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                        • =IFZERO(A1-B1,na())

                                          =IFZERO(A1-B1,na())

                                          this means, that if A1-B1 = zero, then NA() results; if it is not zero, then the result for A1-B1 is shown

                                          2 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

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

                                          Feedback and Knowledge Base