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.

    744 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

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

    • COUNTIFS / SUMIFS with OR - COUNTOR, SUMOR

      Countifs or Sumifs function use all criteria as AND. Instead 2 more formula can be added such that all criteria are treated as OR. Suggested Names of Formula are
      COUNTOR, SUMOR

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

        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

          0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
        • Make/force formulas to work

          Here's my formula: =B66+C66
          That should be super easy. I filled in down to have a running total. I see no reason for it to not work. This is not some super spreadsheet. It's just a worksheet, like scratch paper. Does Excel need to have pretty borders and headers to make it work?
          There are other numbers around, but I'm not getting the chance to say click "Ignore Error"
          I really don't like when Excel tells me something has an error when it doesn't. Ask if it's an error. Let me say ignore if forever or at least in all…

          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

            3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
          • Something Wrong with Countifs?

            I was just trying to analyse - now hot topic, the FIFA data, and used a

            =COUNTIFS($B$4:$B$6,AC9,$F$4:$Z$6,AE$8)

            here $B$4:$B$228 - was the region of the individual member countries, (e.g. UEFA),
            the AC column is the tabulation row

            $F$4:$Z$228 is the rank in the specific FIFA Finals (1..32)
            AE8.... AL8 = 1,2,3,4,8, 16,32

            The formula gives Error i.e. $Value,

            Though two sub-parts work perfectly OK i.e. COUNTIFS($B$4:$B$228,$AC10)
            COUNTIFS($F$4:$Z$228,AE$8)
            both return correct results...

            Is it because one is "String" equality check and other is "Numerical" Equality check?

            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

              3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
            • Add functions to the Status Bar

              Excel's "Customize Status Bar" now lacks text functions, eg. "Most frequent text" in a column, frequency/number of the "Most frequent text". Date and preferably custom functions / macros will be useful too.

              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 →
              • Add options to enable/disable automatic calculations for sheets/workbooks

                I really feel like I shouldn't need to use VBA everytime I want to prevent a single sheet from recalculating all the time. Adding this feature would improve the performance greatly.

                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 →
                • it may be cool for the newer users to have subtraction formulas? multiply and divide as well. could improve a lot and save time

                  so we use autosum or sum for adding correct? well wouldn't it be cool to subtract and multiply and divide using formulas as well? newer users like myself that haven't been influenced by excel a whole lot have to figure out on my own how to subtract two different cells or a whole row of cells for that matter. typing out A2-B2-C2 etc... may seem tedious and pointless. it would be cool if we could just =sub a2:j2? thank you for your time.

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

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

                      7 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 →
                      • Have an option to allow using a VLOOKUP() to work if the lookupvalue is a number, but the table has numbers as Text

                        Have an option that allows using a VLOOKUP() to work if the lookupvalue is a number, but the table has numbers as Text and Vice Versa.

                        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

                          3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                        • If function with criteria range

                          An expansion of the if function to accept a criteria range. The test is,"if criterion is a member of range, then..."
                          I can actually enter this into a spreadsheet without seeing an error, i.e., =if(criterion, $A$n:$A$nn, do if true..), but the results are unpredictable to me.

                          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

                            1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                          • Portugese Excel - Formulas with accents

                            Allow formulas to be inputed with or without accents.

                            Examples: =Média() >>> allow also =Media (without the accent)

                            Índice >>>> allow Indice
                            Não >>>> allow Nao

                            Accents in the formulas are a pure nuissance and dont add anything other than extra work and mistakes. Allowing the command with and without the accent should be very easy and would allow Brazilian users to simply stop worrying about this detail.

                            Th

                            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 →
                              • Formulas that directly format

                                Too bad we don't have formulas that directly format. For example, one might then have a formula like =IF(A1=2,AND("That's a winner!",FILL(A1,[Red]),TEXTCOLOR(A1,[Yellow])),AND("Oh... Sorry!",FILL(A1,[Light Blue]),TEXTCOLOR(A1,[Red]))) .

                                No more screwing with a horrible, non-intuitive, one might even say "broken" given its foibles, conditional formatting. Except legacy work, of course.

                                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 →
                                • Eigenvalues and eigenvectors of a matrix

                                  Add a function or functions to determine the eigenvalues and eigenvectors of a matrix

                                  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 →
                                  • Enable Commenting of Formulas and Functions

                                    Ability to add comments within a formula of function, eg:

                                    =SUM(A1 <!-- Comment Here -->, B1 <!--Another comment here -->, C1)

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

                                      7 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 →
                                      • It is strongly recommended to add file labels, and add functions

                                        1. It is strongly recommended to add file labels.
                                        2. It is suggested that the function EVALUATE be added, to tconvert he macro function of EVALUATE into common function.
                                        3. Add functions by color, such as sum, count, and so on.

                                        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 →
                                        • Extract words from two columns and extract numbers from two columns

                                          A picture of my data is attached. What I need is a formula, preferably a non array formula, in column BZ to extract the Positive and Negative words from column BP first, then from column BT (the words from column BT should be in the first blank cell in column BZ below the words in column BZ that were extracted from column BP) and another formula in column CB to extract the numbers from column BR first, then from column BV. I can have words and numbers in from row 18 to row 417, and how many rows I have…

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

                                          Feedback and Knowledge Base