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

    471 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

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

      Thank you all for your enthusiasm – I’m excited to say that we’re working on it!

      I’m even more excited to say that you’ll be able to try it out soon, as a part of our work to make Excel better understand the data in your spreadsheets. Keep an eye on this page for updates, including instructions on how to try the feature before everyone else – we’ll be using your feedback to help shape our designs!

      -James Spotanski (Microsoft Excel)

    • Colar Especial - Valores Únicos

      Ao copiar dados de uma coluna com vários dados repetidos.
      Como temos a opção com o botão direito do mouse de Colar Especial > Valores, poderia ter uma opção de Colar Especial > Valores Únicos.

      122 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

        28 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
      • Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

        It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

        This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

        It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

        84 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
        • Option to show list of sheets sorted by name. Today it's only sorted by index.

          Option to show list of sheets sorted by name. Today it's only sorted by index.
          In English:
          Option to show list of sheets sorted by name. Today it's only sorted by index.
          When we right click on the navigation arrows (bottom left corner of Excel), Excel shows us a list of the worksheets sorted by index/position in the workbook.

          Suggestion: add a checkbox or a combobox to that dialog box, with a couple more options, like the attached image:
          Index Asc
          Index Desc
          A to Z
          Z to A

          This is not to move the sheets around, this is to…

          42 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

            7 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
          • Add Center Across Selection to the Merge & Center Drop-down

            Do you hate Merged Cells? Do you believe Merged Cells are evil? Do you curse every time your selection rectangle goes from one column to five columns just because you touched a merged cell? Do you constantly get workbooks from co-workers who continue to merge cells? Tired of not being able to Sort or Paste because someone merged a cell?

            Excel encourages people to use Merge & Center by offering it front-and-center on the Home tab. Thus, few people discover the (superior) Center Across Selection option on the Alignment tab of the Format Cells dialog.

            Currently, the Merge & Center…

            213 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
            • Power Query - Add option to retain all cells (nulls and errors) when using Unpivot Other Columns

              Using Power Query to Unpivot other columns is an amazing feature but it automatically removes nulls and errors.

              Add a drop down down (maybe an advanced option) to Unpivot Other to allow the keeping of all items

              14 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

                3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
              • Custom Format for Brazilian months in capital

                Allow mmm or mmmm custom formats to capitalize first or other letters of the months by using
                Mmm / Mmmm instead or even
                MMM / MMMM

                Specially for portuguese/Brazil. By using custom format, we always have month in lower case.
                We all want to be able to custom format the date and see:
                Jan/2018
                Fev/2019
                Abr/2020
                Out/1979

                But in portuguese, only portuguese, this never happens.

                19 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                • May 2017 update which keeps the copied item active in the clipboard

                  Regarding the issue of...It's part of the May 2017 update which keeps the copied item active in the clipboard even if you do things that would normally clear it, like typing in a cell, applying formatting, etc.

                  Pressing ESC will clear the marquee/dancing ants.

                  Why in the world would Microsoft and an extra step here. This is terrible. At least give us the option to turn off the function. Please change this back or give us the option. Very disappointed!

                  303 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

                    159 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                  • Disributed calculation (with colleagues computers)

                    I'm sure that Microsoft's experts will be able to optimize the Power Query code. However, almost certainly there will be users with very massive models that update very long. Please add the possibility of using distributed computing to process Power query queries.
                    It would be very cool if we will be able to configure in a simple interface wich of colleagues computers in the local network (and maybe on the Internet), whose resources, can be used to speed up the calculation. And when processing queries, use avialable resources together.
                    In addition, the use of distributed computing in a local network…

                    13 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

                      5 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                    • Formular Editor

                      Large formulas become very confusing. It would be nice if there is a formula editor that inserts, coloring and evaluates the formulas like Visual Studio and that can also be provided with comments and other hints. These formulas must then be displayed in the editor in exactly the same way.

                      20 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

                        3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                      • VBA abilty to refresh a Power Query Group (a.k.a. folder of queries) using a single script line

                        We need a VBA solution to allow a module/macro to refresh a Power Query Group by name. This solution would allow a single line of VBA code to refrence the Power Quer Group (folder) Name and refresh all queries within that folder.

                        It could be something as clean as:

                        ThisWorkbook.Connections.Group("My Folder of Queries").Refresh

                        17 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

                          0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                        • Reinstate the ability to open multiple workbooks in a single instance in Excel

                          I do not understanding the logic behind your decision to remove the ability to open multiple workbooks in a single instance in Excel. The only benefit is the ability to immediately move work books to two separate screens basically giving the ability to do the simple task of copy and paste. FYI: available on all spreadsheets!!! What made Excel a valuable tool was it ability to reduce time by accumulating data from multiple workbooks instantly and limiting the use of resources (ram). It also reduced the amount of data on a single workbook and protected the master since a simpler…

                          91 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            19 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
                          • Excel new Feature Request - adding new xlNotFilterValues enum to AutoFilter

                            Recently, an user ask me to add a filter with a criteria that is equivalent to filter all values that are NOT in the list.

                            In Excel, the only Operator enum that I can use for AutoFilter method is xlFilterValues.

                            In this case, criteria must contains a list of values in a String array. I have developed some VBA code that extract in a Collection all possible distinct values that a column can contains, that remove not acceptable values and that save all these values in an array that I pass to AutoFilter(xlFilterValues) method. This work well, but it is…

                            11 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                            • Unhide multiple worksheets at once

                              We can hide several worksheets at once, but we can only show them individually.

                              Although the VBA can solve this issue with some lines of code, but it would be a great improvement if you add this capability to Excel as a build in feature.

                              81 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

                                4 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                              • Please remove autosave!

                                I use excel for 90% of my job and am seriously debating leaving the MSOffice ecosystem entirely, purely due to auto-save destroying my files. This is the WORST idea Microsoft has come up with and has cost my company hundreds of hours

                                4 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

                                  4 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
                                • turn off automatic date conversion

                                  Opening scientific data in excel for review or analysis purposes is a nightmare in Excel. Some values, gene names and other text automatically transforms into dates and then the data is corrupted. Changing cell format in this case corrupts the data even further and there's no way to return to the original value/text, since the data corrupts when opening the file. This is the worst functionality in Excel and I don't know anyone who benefits from the automatic transformation of dates. Please the date transformation optional setting for those who might need it!

                                  9 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

                                    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Image Underlay

                                    An image underlay for the spreadsheet that can be adjusted and held to a specific size. This way cells on top can be used. Opaque Image overlays (watermarks) stop the use of cells under them, and Backgrounds are very hard to control and they tile across all pages which is very anoying. A background setting that allows adjustment to the size of the image, locking of aspect ratio and having a Tile on off function could suffice.

                                    5 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      1 comment  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Embed objects and graphics alongside text in a cell

                                      Embed objects and graphics alongside text in a cell so that the object or graphic can move with the text as edits or links are made to that cell. Also, enable embedded objects and graphics to be defined and changed within the text according to logic arguments.

                                      10 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        2 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Filtering Needs to Work in Co-Authoring

                                        Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
                                        Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
                                        It is more important to us to be able to have each person apply a local…

                                        39 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Excel 2016 : ClearContents is 3 times slower than Excel2010

                                          My customers reported me that my product (Excel Addin) becomes slower after they updated Excel from 2010 to 2016.
                                          By analyzing the problem it turned out that main reason of the slow performance is 'ClearContents'.
                                          I setup two same hardware condition machine. I installed Win10 into them. Then I installed Excel 2010 on the machine A.
                                          And I installed Excel 2016 on the machine B.
                                          By using the following code, I measured the time to ClearContens.

                                          It takes 2859 ms on Excel2010 (A) . It takes 9719 ms on Excel2016 (B).

                                          Generally thinking , a customer will expect faser performance…

                                          17 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            1 comment  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 195 196
                                          • Don't see your idea?

                                          Feedback and Knowledge Base