Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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.

    649 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

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

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

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

      Again, we genuinely appreciate your involvement as we…

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

      40 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 →
      • Allowing Multi-Select Functionality Through an Option List (Data Validation List)

        As a Web developer and data management professional, my job relies on many functions that help me to get the work done faster. I was asked to create an excel sheet to import data faster into our website through a massive update. I got stuck at a task where one of the attributes had multiple options. I didn't know how to do so without having to create a list of all possible combinations which passed 40k possible combinations. I was losing my head until I searched online. I found a Macro Code that helped me select multiple options for a…

        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

          0 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

          25 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 →
          • Add new Split formula

            I want to add new formula called "split"
            The formula will split cells or text upon a delimiter like "split" in vba
            formula syntax:
            =split(delimiter,cell or text)

            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

              2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
            • Improve the way Excel handles dates in a regular spreadsheet formulas

              It is just RIDICULOUS that Excel still can't handle dates before
              1900. If Excel was an also run to Lotus 123 or some other ancient spreadsheet, I could understand them sticking with that, but it isn't.
              There are tens of millions of people who would like to do calculations on dates before 1900 -historians, astronomers, archeologists, scientists, and just plain genealogists - professional or amateur.

              From https://www.techonthenet.com/excel/formulas/date.php
              The DATE function returns a serial date value. A serial date is how Excel stores dates internally and it represents the number of days since January 1, 1900.
              If the year is greater…

              2 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 →
              • User defined 'functions' in a worksheet with input and output cells

                Create a new type of 'worksheet' which acts in the same way as a VBA function, but instead of writing code you use the worksheet itself to create the logic.

                A designated set of cells would be used to specify inputs, which the rest of the sheet could refer to as normal using formulae.

                Then one cell would be designated as the 'output' cell.

                Finally a function name is assigned to the worksheet which can be called from anywhere else within the workbook

                e.g. =MySheetFunction("Input1", 234.56)

                In the background, Excel calculates what the output cell would equal given these two…

                1 vote
                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 →
                • Please fix the M3 bug!

                  It needs to be easier to reference cell M3. As it stands, the 3 is automatically superscripted.

                  1 vote
                  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 →
                  • There should be numeric data type restrictions

                    I am working on some custom functions in VBA and the range of values for data types are absurd.

                    Double data types can run to hundreds of digits even though they couldn't be seen on the screen.

                    1 vote
                    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 →
                    • Graphical wizard to assist with VLOOKUP and similar FOrmulas

                      When configuring VLOOKUP in Excel, there should be a graphical wizard which will walk a user thru setting up the VLOOKUP.

                      1 vote
                      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 →
                      • Evaluate Formula Box- Apply color coding

                        Evaluate Formula Box- Apply color coding for most recent calculation and upcoming calculation, instead of underline and italic!

                        1 vote
                        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 →
                        • Numbers converting in words function

                          Pls add the function of converting numbers in words, doing it through VB insert option is quit hectic problem.

                          1 vote
                          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 →
                          • Error in Textjoin formula

                            Textjoin sometimes gives empty results:
                            ==============================
                            Textjoin formula is found in "Annual_leaves" Sheet
                            =TEXTJOIN("+",TRUE,IF((Report!$B$10:$B$200=$A2)*(Report!$C$10:$AD$200="A"),Report!$C$8:$AD$8,""),"")
                            examples of the results:
                            "16" or"16+21+23" or "02+11+24+27"
                            My formula usage:
                            ==============
                            It brings annual leaves dates from sheet "Report" for every employee
                            The problem:
                            ==========
                            >>>When you edit a cell in another sheet rather than "Report",textjoin will show blank results
                            Steps to produce the problem:
                            ======================
                            1-Edit any cell in sheet "Attendance"
                            2-then go to sheet "Annual_leaves" ,you will find textjoin show empty results
                            see the attachment

                            2 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                            • 1 vote
                              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 →
                              • Why does Excel STILL LACK equivalents for some Google Sheets functions?

                                Specifically FILTER, SORT and UNIQUE.

                                I spend too much time in Excel user-to-user support forums, yet one of the most frequently asked questions is how to find conditional matches. Google Sheet's FILTER function makes these tasks almost elementary. Excel equivalents require INDEX(..,MATCH(1,(condition1)*(condition2)*...,0)) and array formula entry.

                                When are certain portions of Excel functionality FINALLY going to progress from the 1980s?

                                1 vote
                                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 →
                                • Formula bug in Excel (?)

                                  Hello,
                                  I've probably found a formula bug. I've attached a replicate scenario (pdf document) and also the Excel sheet to reproduce the bug.
                                  Sorry if there are some mistakes, English is not my native language.
                                  Regards,
                                  Sophie

                                  2 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Inserting Formula

                                    When you insert a FORMULA from the FORMULA ribbon or when you select INSERT FUNCTION in the formula bar, you get a helpful graphic that guides you in building the formula with the option of selecting HELP ON THIS FUNCTION for more detailed help.

                                    When you are working on a formula, if you click the formula name (e.g. SUM in the example attached), it opens up a HELP window. It would be more useful if it opened up the FORMULA build window instead (which also has the ability to click a link for further help).

                                    This would allow users more…

                                    1 vote
                                    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 →
                                    • STANDARD ERROR OF THE MEAN

                                      Please add a formula for Standard Error of the Mean as well as an option to use this statistic for error bars. This is a standard statistic used in data visualization. I can't believe it hasn't been added at least 10 years ago.

                                      1 vote
                                      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 →
                                      • Add chmistry data type. at the minimum it should recognize elements.

                                        Add chemistry data type. At the minimum it should recognize the elements and properties.

                                        1 vote
                                        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 →
                                        • Button to Flatten formulas in visible cells

                                          Need a button that replaces the need to unfilter an entire sheet full of large amounts of data in order to copy and paste values in a column that were formulas. The large amount of data results in major slowness when unfiltering or sorting. To avoid the slowness, I will unfilter the sheet then copy the column and paste values to flatten the formulas. The unfilter part of the process can take forever and often crashes excel. There is a need for a button that after selecting visible cells (column or selected cells), can flatten the formulas to values. This…

                                          1 vote
                                          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 →
                                          ← Previous 1 3 4 5 29 30
                                          • Don't see your idea?

                                          Feedback and Knowledge Base