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

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

      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

        13 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
      • Random value generation

        Idea:
        Excel might have a built-in function for generating random values.
        Two 1-dimensional and identical long ranges can include inputs for both the values to be returned and the corresponding weights.
        E.g. ["apple","orange","apricot"] [10,20,30] -> 30/(10+20+30)=50%, 50% is the probability that the returned value is "apricot".

        Rationale:
        -This solution can help to generate datasets with predefined parameters. This can help in teaching, training and modeling activities.
        -The same approach can be applied for generating timestamps with predefined parameters. This could be utilized for data analysis (monthly, weekly, daily seasons, distributions etc.).

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

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

            21 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 a BETWEEN function & operator

              The BETWEEN function is in Microsoft Access, it should also be in Excel. And one could use the operator >< to represent it. So you would have:

              =15>A1<25 or =BETWEEN(A1,15,25)
              ="A">A1<"C" or BETWEEN(A1,"D","L")
              =DATE(2020,1,1)>A1<DATE(2020,4,5) or BETWEEN(A1,DATE(2020,1,1)DATE(2020,4,5))

              wildcard (*, ?, and ~) could be applied:

              ="D">A1<"L??" or BETWEEN(A1,"D","L??")

              Use the same definition of BETWEEN as MS Access.

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

                37 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 →
                • 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)

                  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

                    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add TopN optional parameter for new Dynamic Array functions

                    The new Dynamic Array functions are awesome, but it would be nice if we could tell them to only return the TopN results via an optional parameter. So =SORT(A1:A10,,,5) would just return the top 5 items after the sort was done.

                    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

                      1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                    • To be able to select the last instance of a text in SUBSTITUTE or FIND

                      The SUBSTITUTE function allows the user to specify the instance of a text to be replaced. However, there are many cases where one wishes to identify the last instance in a list where the number of instances varies (example: a list of files with multiple folder paths of different lengths; I want to identify the final '/' so that I can extract just the file name).

                      My suggestion is a third option for how the [instance num] in the function SUBSTITUTE(text, old_text, new_text, [instance_num]) is used; the user should be able to specify something like "Final" (or some other string)…

                      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 →
                      • New Lookup Function for Simple Table Lookups

                        Excel has many functions about lookup and reference, e.g. VLOOKUP, OFFSET, MATCH etc.
                        However, over the years with Excel I have always missed a very useful lookup function from Lotus 123. It was called XINDEX and was used for very basic lookups in a two dimensional table. XINDEX had three arguments:
                        1. A range name, e.g. TEMPERATURE which could be A1:M6.
                        2. Header name of column to search in, e.g. one of the twelve calendar months
                        3. Header name of row to search in, e.g. Boston, London, Beijing, Melbourne or Kinshasa
                        In our example table we could for instance have…

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

                          864 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

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

                          • Allow names being entered as array formulas

                            Allow names being entered as array formulas

                            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 →
                            • I would like to be able to add cells based on their cell color.

                              I would like to be able to add cells based on their cell color. Add cell properties to SUMIF or functions to Conditional Formatting

                              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 →
                              • MID function - Make the 3rd argument optional

                                Change the MID function so the third argument (num_chars) is optional.
                                >If left blank, it would just pull the rest of the text string.
                                >If populated, it pulls that number of characters, just like it has always done.

                                I typically use MID to extract the rest of the text string, starting in the middle. Right now I put LEN(A1) or 10000 in the 3rd arg to ensure it pulls enough characters. If that were the default, it could be done to speed up processing.

                                This would still be backwards compatible with previous versions of Excel since all existing functions would…

                                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 →
                                • 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 →
                                  • Create a simple NEGATIVE() function

                                    Consider creating a NEGATIVE() function. This is not the same as ABS(). Rather for any number N in cell X# NEGATIVE(X#) function = -1*(N). Example: Cell F3 = 52.73. NEGATIVE(F3) = -52.73. And NEGATIVE(NEGATIVE(F3)) = 52.73.

                                    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 →
                                    • Removing "x" number of characters from a string without knowing string length

                                      I think it would be very useful to have functions similar to LEFT and RIGHT that tell Excel how many characters to remove instead of how many characters to keep.
                                      An example: After extracting a specific chunk of data from another cell (using a complex formula), if I want to remove any more characters (units of measure, etc...) I would need to either have a helper column, or more than double the current formula to extract all that text for a LEN measurement, then extract all that text again for the removal of a few characters from the end.

                                      Having…

                                      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 →
                                      • Fix the long-standing Excel bug that stops Ctrl+H searching and replacing in Values and in Comments. 64-bit MS Office I

                                        Fix the long-standing Excel bug that searching and replacing in Values and in Comments unavailable when using Ctrl+H. I just got upgraded to 64-bit MS Office and this very valuable function has simply stopped working for me. The issue doesn't affect every instance of Excel, but even so the Internet is thick with people posting the same issue since at least 2007, so c'mon Microsoft, how's about you fix it!!

                                        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 →
                                        • Should be able to add comments to formulas like you can in Power BI and Power Query

                                          Need the ability to add comments to formulas like we can in Power BI and in the Power Query Advanced Editor.

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

                                          Feedback and Knowledge Base