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

    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

      4 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

      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

        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
      • 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.

        810 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

          287 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

          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

            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.

            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

              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.

              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

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

                16 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 →
                • replace Count by CountA

                  replace Count by CountA
                  In the home ribbon, change the quick function (sum, average, count...).
                  I think that we need COUNTA more than COUNT.

                  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

                    0 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

                      0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                    • A =CORRELIF(S) Formula

                      It would be the =CORREL formula with added IF criteria, such as SUMIF, to allow for easier correlation between specific categories in one data set.

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

                        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 →
                        • Save User Defined Nested Formulas in the Formula Tab

                          I have numerous nested formulas that I create from time to time. I would like to see a section in the Formulas Tab where user defined nested formulas, with their defined name, can be selected from a drop down list.

                          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 →
                          • When Excel is used as a "Form"

                            Sometimes Excel is used as a "Form" where users can fill in data. Sometimes the data that they fill in has associated logic, the "IF" function.
                            They can enter anything in the cells including "spaces" and "clear contents". But the required logic is that these things be ignored.
                            The only way around this so far is to create a "mirror ghost sheet" that translates this scenario to ABSOLUTE VALUES.

                            eg. =IF(OR($A$1<>"",$A$1<>" ",$A$1<>" ",$A$1<>" "),0,1)

                            The cell is Visually Blank. Can we forget the Boolean purist thing and treat this a One Logical Condition, and have an operator such as VBLANK…

                            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 →
                            • 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 →
                              • 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 →
                                • 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 →
                                  • Change how Calculation Options work across multiple workbooks

                                    Currently, the Calculation Options in Excel seem to have some odd behaviour:

                                    Principally, the setting is specific to the workbook, but I set up 2 books as a test:

                                    Book1 - Manual calculation
                                    Book 2 - Automatic calculation

                                    When I ONLY open one of the books, the calculation setting is correct to what I had set on it. However, if I open the other workbook when the first one is still open, the setting pulls across to the second book.

                                    So:
                                    If I open Book2 (automatic) first, then open Book1 (manual), Book1's calculation setting becomes "Automatic"
                                    If I open Book1…

                                    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 modify the Name Manager

                                      Please modify the Name Manager such that when the name given to a cell is deleted, formulas in other cells that were based on that name are updated based on the actual cell address rather than keeping the formulas with references to the deleted name.

                                      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 →
                                      • Nova função que utilize a equação escrita em uma célula e automaticamente substitua os valores de uma linha em sua variável independente e r

                                        Suponha que você escreva uma função na célula A1
                                        Exemplo: Você escreve em A1 a função: x^3+LN(x)

                                        No lugar da variável independente x você deseja substituir valores que se encontram em uma determinada linha (exemplo: os dados que se encontram na linha entre as células B2 a B10) para que retorne solução da função (exemplo: retorne a solução na linha entre as células C2 a C10).

                                        Atualmente, poderíamos resolver esse problema digitando em cada célula na coluna C de C2 a C10 a função desejada. Exemplo escrever na célula C2 a função: =B2^2+LN(B2); na célula C3 a função: =B3^2+LN(B3); ...e…

                                        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 →
                                        • Documentation Defect in SUMIF(): contradictorily defines use of sum_range

                                          A "documentation defect" has been reported to Microsoft which Microsoft has flat-out denied I suggest Microsoft correct the documentation defect below. Anyone else agree?

                                          In the main documentation Microsoft states:
                                          "• sum_range Optional. The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied)."
                                          There is no indication that the cells added might differ. The statements are absolute.

                                          Down in the Footnotes and Remarks Microsoft clarifies…

                                          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 33 34
                                          • Don't see your idea?

                                          Feedback and Knowledge Base