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.

Take a look at the feedback that we are currently working on and what feedback we have already completed.

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.

    58 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      32 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    • Ability to reference the end of the column or row regardless of the starting position

      I can enter A:A to reference the entire column or 1:1 for the whole row, but if I want to go from A2:A, I have to enter a number for the end of the range.

      What if I don't know where it ends? Or where it may end someday? If I type A2:A10000 I'm safe only as long as my data doesn't exceed 9,999 rows, which is hard to determine. I want to reference the whole rest of the column regardless of how much it expands in the future.

      And because of this, sometimes a reference like A:A in conditional…

      34 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        9 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
      • Set a range as "Absolute" values

        I use a same range to enter minus(-) values and also plus(+) values to differentiate between negative and positive.
        However i need to SUM this range as a whole (i.e. a credit/debit column) = this is difficult to do as sum function will +/- the values
        If i can set that column or range as an "Absolute" range, then SUM and other functions can honour the abs() value if need be

        4 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
        • Advanced formula manager

          Excel has gone a long way of development and continues to acquire new functionality. However, the original concept of a tool for tabular calculations with formulas does not develop. The mechanism for entering and checking formulas is obsolete.
          Prerequisites for a new tool:
          1) The built-in mechanism for entering formulas does not allow you to immediately check the calculation stages for correctness and check the logic. You must first enter the formula, and then look through the step-by-step calculations. If you need corrections, you have to go back to the formula editing field.
          2) When you enter a nested formula…

          21 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
          • Formatting codes need to be translated inside formulas

            The formatting codes are different in every language, so for example, for the day is "d" in English, "g" (from "giorno") in Italian, "T" (from "Tag") in German).

            Working in a multi-language environment where different users have different language settings on their PC gives the problem that when you write a formula that contains the formatting codes, the formatting codes are not translated and the formula doesn't provide the intended result.

            For example, if I, with language settings in Italian, want to write a formula to display the current date as text in English, I have to use the following:…

            43 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              7 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
            • [Bug]Trim function does not work properly

              It doesnt show leading space if i use trim(), but if I press home and then press delete, it does not delete the 1st char. It still has some hidden blank space. I have to hit delete button twice to remove 1st character of string. This is causing issues in search and ultimately in Vlookups as it is not able to find the string.

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
              • How about some geodetic functions?

                It would be nice to see some geodetic functions like great circle distance between two points, final lat/lon given a starting point/direction/distance etc. Vincenty's approach for direct and indirect solutions is pretty reasonable to implement.

                2 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  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 known issue of DATEDIF function in "md" unit and document this function!

                  There is no justification for keeping this useful function undocumented since there are no alternatives to it.

                  Please document this function and fix the known issue of "md" unit!

                  By the way, the workaround for the known issue that you provided on the below support page isn't complete workaround!

                  https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c

                  Because it does not take into account the start date!
                  It only gives you the correct result if the start date is the first day of the month.

                  What if the start date was: 9/9/2014 and the end date was: 7/24/2016

                  That workaround will give me the result of 23…

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                  • Highlight cells with hardcoded values vs. formulas

                    When processing larger files with financial data, we regularly spend time hunting for cells containing hardcoded numeric values (from "Paste as Value") rather than formulas. I know some of this can be solved using conditional formatting, but if we do that the original formatting is lost.

                    It would be helpful to have somewhere in the Formulas tab an option to "Highlight cells with Values", like we have "Evaluate formula" and "Trace dependents". I could see a few categories here:

                    - pure numeric values
                    - formulas mixed with numeric values (e.g. "A1+B2+100")
                    - formulas referencing only the current sheet
                    - formulas…

                    11 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                    • Ruby(or mRuby) as an Excel scripting language

                      Although there's less usage in science computing compare to Python, Ruby still a powerful & flexible scripting language and easy to programming, hoping it could be another candidate language like Python

                      1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                      • Ruby(or mRuby) as an Excel scripting language

                        Although there's less usage in science computing compare to Python, Ruby still a powerful & flexible scripting language and easy to programming, hoping it could be another candidate language like Python.

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          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 new formula that return the last formula of a cell

                          Assume

                          formula in B1
                          =IF(SUMPRODUCT((CELL("address")=CellControlTable[CellColumn])*1), DoSomethingFormula(), IFERROR(LastValueInFormulaForm($B$1),""))

                          and focus currently in cell: A1.
                          I change the contents in A1 that its address is in CellControlTable. B1 value is changed by formula in [true part]. Then, i change cell:Z10, which is not in cell control table. In this case B1 keep no changes and the content is still in a formula form.

                          I don't want a macro solution.

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                          • Adding back what was available in office 2003 & 2007. Great features missing. For excel Previous & next arrows when you add a link.Thanks

                            Adding back what was available in office 2003 & 2007. Great features missing. For excel Previous & next arrows when you add a link.Thanks

                            1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add if like functionality to more mathematical functions

                              Currently SUM and COUNT function classes have additional IF functions to do conditional operations. Please add similar functions to more mathematical functions especially statistical functions to make the product more versatile and user friendly.

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                              • improve convert function

                                Allow user to insert custom conversions. Example: I work in the oil industry and use the volume unit of barrels frequently (42 us gal /barrel). It would be nice to be able to customize.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                • Increase print size on ribbnons for Office

                                  I have a few sighting problems, and whilst I can increase the print size for all working areas, I cannot (have not yet found) a way of increasing print size in the Ribbons. For me the print size is unreadable, so I have to get out a magnifying glass to get settings correct, Making the entire pane bigger will help enormously.

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                  • A GLookup function

                                    We already have VLookup and HLookup, how about GLookup that would allow me to find a value in a grid by passing a value for the X & Y axis of the grid, then returning the value in the cell that intersects. This is how I envisage it:

                                    =GLOOKUP(["TABLE" RANGE],[HLOOKUP VALUE],[VLOOKUP VALUE],[TRUE/FALSE])

                                    2 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Enhance a bit of Hyperlink formula

                                      I want hyperlink click event without using vba.

                                      cell("address") can help me to find the last edited cell. if Hyperlink can trigger this, then, other cells can use cell("address") in formula.

                                      Hyperlink(link, [friendlyname],[Trigger cell formula(0-true,1-false,default:1)])

                                      2 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Ctrl + U - Last Update Office 2016

                                        In the last update of Office 2016 there was a change in the action of one of the Excel commands.
                                        The Ctrl + U command, before the update, always had the action to open the Excel REPLACE window.
                                        After the last update this command is directed to the LOCATE window.
                                        There is already a command for the LOCATE action, which is Ctrl + L.
                                        It does not make sense to have two different commands for the same action (LOCATE).
                                        The command Ctrl + U (REPLACE) has always been very useful in my activities.
                                        Can you correct it?

                                        2 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Expose Excel ODBC Driver SQL or ACE OLEDB Provider SQL for Excel workbooks through a built-in function in Excel.

                                          Currently I can achieve this functionality by creating an external data connection to the workbook using Microsoft Query. but the drawback is I need to change the location of the Excel file in the connection string information within the connection properties dialogue every time I change the location of the Excel file or share the workbook with anybody. There should be a way of always referring to the current workbook. So the functionality can be a function like below-
                                          =SQL("SQL Syntax for querying excel worksheet/range", "optional location of excel file. Default to current workbook")
                                          The result of the function can…

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            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 22 23
                                          • Don't see your idea?

                                          Feedback and Knowledge Base