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.

    947 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

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

      Hi everyone,
      Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

      One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

      We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

    • Convert Dynamic Arrays into Tables

      The new Dynamic Arrays make possible to automatically fill down formulas. Tables can also fill down formulas. Microsoft Excel Team could make both features be compatible so we could convert Dynamic Arrays into Tables making them expand and shrink according to the main formula.

      35 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 →
      • Function and formulas recommended

        Mohammed A Elrify
        Mohammed A Elrify Occasional Contributor

        4m ago

        Suggested to Microsoft EXCEL
        By creating the advantage of the proposed Function and formulas recommended
        Such as recommended pivot tables and recommended charts

        For example, the work of options for the user
        For example if he wanted to compile on terms, he would have the formula SUMIFS ready and only a choice
        Also like the search that VLOOKUP uses
        And so on
        I hope the Microsoft community will support and encourage this idea

        72 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

          17 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
        • Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from -pi to +pi 3)atan2(x,y)

          1)atan(x,y)=pi-pi/2*(1+sgn(x))*(1-sgn(y^2))-pi/4*(2+sgn(x))*sgn(y)

          -sign(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

          2)atan(E,N)=pi-pi/2*(1+sgn(N))*(1-sgn(E^2))-pi/4*(2+sgn(N))*sgn(E)

          -sgn(N*E)*atan((abs(N)-abs(E))/(abs(N)+abs(E))) when N=N2-N1 ,E=E2-E1

          3)atan2(x,y)=pi/2*(1-sgn(x))*(1-sgn(y^2))+pi/4*(2-sgn(x))*sgn(y)

          -sgn(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

          The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.

          For dx=dy=0 the result is indefinite .

          87 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

            15 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
          • COUNT.DISTINCT Values

            Proposal for a built-in function for: Count distinct/unique values in a range

            There might be a dedicated function for counting distinct values in a specific range.
            Currently the following function is a solution:
            =SUMPRODUCT(1/COUNTIF([RANGE],[RANGE]))

            However beginner-level users would like probably a predefined parametric function, sg like this:
            =COUNT.DISTINCT([RANGE])

            Thank you.

            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

              3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
            • Make the Evaluate Formula dialog box re-sizable

              The evaluate formula box is unusable with large and/or CSE formulas. Please just make it re-sizeable. Thank you.

              35 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 →
              • Add cell reference to Data Validation Messages (Input Message, Error Alert)

                Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
                This would make possible to use variable contents.

                Thanks,
                Fernando Fernandes

                27 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 →
                • Allow column name to be used in vlookup

                  Allow the VLOOKUP formula to recognise a column label in place of the column count. This is a sorely lacking functionality when referencing large data sets that can easily extend to column counts of 50 or more.

                  Example: =VLOOKUP(A2,F:AM,AM,false) instead of =VLOOKUP(A2,F:AM,34,false)

                  12 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                  • Perform Calculations (Sum, Count, If, etc.) Based on Cell Color

                    Allow users to create formulas and that perform specified operations with data/values from only cells with a chosen background color, from a range of cells.

                    For example, in a range of 10 cells (A1:A10), only 3 cells have been colored yellow (either by the user or by a specified condition). A user can create a formula, such as =SUM or =COUNT or =AVERAGE, that will only use the cells colored yellow to determine the result. All other cells in the range, regardless of background color, will be excluded from the formula's result.

                    Alternatively, the same functionality can be achieved based…

                    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

                      0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                    • Name a dynamic array (rather than use "A1#" notation)

                      The new dynamic array notation is incredibly powerful, but one thing that makes formulas complicated is the "A1#" notation when used in formulas.

                      It would be great if you could (easily) assign a name to it in the same way that you can name an Excel table.

                      It would be much easier to see:

                      =SUMIFS(TABLE1[totals],TABLE1[dept],departments)

                      than

                      =SUMIFS(TABLE1[totals],TABLE1[dept],B1#)

                      I am able to define a named range for these values, but that is a bit clunky. It would be great if the naming was exactly the same as Table naming (e.g. in an ARRAY context menu like the TABLE context menu).

                      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

                        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add a formula formatter (similar to PowerApps)

                        PowerApps has a great feature that allows you to format (and un-format) a formula with the press of a button to help make it more readable.

                        Excel need the same.

                        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 →
                        • allow users to use =avg instead of having to type out the full =average

                          allow users to use =avg instead of having to type out the full =average. Having to type those four addition characters of has cost me decades of life. Why not? How hard would this be to code?

                          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

                            1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                          • From to infinity

                            I am reluctantly using Google Sheets for freelance work. There are a couple situations that have come up that make me wonder why Excel doesn't do it already. This is one of them.

                            In a formula, when I want to 'future proof' a template, I want to say B10 and the rest of column B, for example. In Excel, I can't do that. In Google Sheets, I can say 'B10:B' and anything starting from B10 and below will be factored into the formula. Any formula. Bliss. So simple and powerful and yet not advertised in Sheets and impossible in Excel.…

                            6 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 →
                            • IF function

                              Hello Dear team.
                              There are cases when we see more than 10 IFs within one formula, then we have to understand which IF (of those 10) for the moment supersedes/works for the highlighted cell.
                              You may visualize it as flashing text for the certain IF part.
                              Thank you in advance.

                              3 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 →
                              • Make protected file contents unavailable unless file is open

                                In a nutshell, create a password protected file with, say, "1" through "10" in A1:A10, save it, close it.

                                Now open any file and create a simple formula to read cell A1 in the just protected file.

                                And... it reads it and outputs the value. Copy down and it continues to do so for cells A1:A10. (And reading A11 generates a "0" just as referencing some blank cell in the open spreadsheet will.)

                                So... where is the protection?

                                This should FAIL unless someone on the computer in question has ALREADY successfully opened the protected file. As in, only after someone…

                                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

                                  1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                • Text Interpreter Function without Evaluate()

                                  I would like to harness the ability to evaluate a text formula expression in a range or table. I was wondering if anyone else has thought about this before. It seems that FORMULATEXT() or INDIRECT() could be used for this purpose but alas..... it seems they cannot. Basically, the scenario I would find it most useful would be the ability to set up a formula lookup table and essentially do a vlookup to get the correct formula to use for a particular variable. This would eliminate the need to inject custom VBA functions or use EVALUATE(). This type of functionality…

                                  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

                                    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                  • be able to add hyperlinks to comments in excel

                                    be able to add hyperlinks to comments in excel

                                    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Live exchange rates in excel (compliment to the new stock features)

                                      The new stock feature only displays stock prices in the currency on the exchange. The ability to convert between different currencies (ether in the stock feature or as a separate function) would be great and remove the need for many (including me) to copy paste exchange rates from the internet.

                                      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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                      • INDIA's Currency Symbol is missing

                                        Please add the all countries symbols of currency in Microsoft Excel.
                                        Specially INDIA's currency symbol because if i am not wrong number user is very high in india of your product and they definitely found lack of our symbol in excel when they need.

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

                                          Feedback and Knowledge Base