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. Add the BANG function for statistics Please

    The ! (pronounced BANG) function is useful in statistics. If for example I
    have 5! it means 5*4*3*2*1. When calculating odds it is a slick way of making calculations less complex.

    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

      6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    • Hello, i have a need to round values up in the example "roundup say 6.2 or 6.3 to 7"

      Is there a way to round up any fraction of a positive integer to the next positive integer - e,g, 6.1 to 7?

      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 →
      • Be able to pastspecial the content (basically the code) of a specific Cell without entering in the cell and select/copy the line

        For example if the content in Cell A1=SUM(B1:C1), you should be to paste this content: "=SUM(B1:C1)" where you want, for example in Cell A5, without locking cells. It could be useful when we have to copy and paste formulas from a workbook to another one (without the problem of REF)

        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 →

          Hi Simone,

          You can do this in Excel already today. Instead of copying the entire cell (by selecting the cell in the grid), double click on the cell to enter edit mode, select the formula, and copy it.

          Paste that into the destination and it won’t adjust.

          Cheers,
          Dan [MS]

        • colour cells

          Be able to calculate the occurrences of cells with coloured background.

          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 →

            Hi Amy,

            This is already possible in Excel today.

            1. Press Ctrl+F to open the find dialog.
            2. Click “Advanced”
            3. Click on the “Format” button and select the format (cell colour) you want to count
            4. Click Find All

            The find dialog will list the count of occurrences of that formatting that you selected.

            Cheers,
            Dan [MS]

          • quick analysis improvements

            We need better sum and subtract quick analysis features that include the number in an existing cell rather than paste to a new cell reference. Especially helpful would be the ability to quickly subtract some positive values from another.

            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 →

              You can do this already.

              1. Copy the values you want to subtract from other values.
              2. Select the range you want to subtract those values from and choose Paste Special > Subtract

              Cheers,
              Dan [MS]

            • Allow me to insert things like 1-9 without automatically correcting to the date.

              basically what the title says. This is a thorn in my side, as there's no existing type of cell format for this input.

              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 →

                Hi,

                You can do this already in Excel today – there are two ways:

                1. You can type an apostrophe before the data you enter → ’1-9, and Excel will then not interpret that as a date (it will interpret it as Text).

                2. If you format the cell as Text before typing the value in the cell, Excel will not interpret it as a date.

                Hope that helps,
                Dan [MS]

              • Countifs with multiple choice in the same range: COUNTIFS (A1:A20;">=32";A1:A20;"<85")

                Allow countifs to manage < and > in the same range.
                Example
                NOW: COUNTIFS (A1:A20;">=32")-CONTA.SE(A1:A20;"<85")
                IN THE FUTURE TO HAVE THE SAME RESULT:
                COUNTIFS (A1:A20;">=32";A1:A20;"<85")

                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 →
                • have a amortized schedule not just for loans, but also for lines of credit

                  have a amortized schedule not just for loans, but also for lines of credit

                  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 →
                  • Excel convert signs

                    It would be really efficient to have a functionality in Excel to be able to convert the numbers sign (Positive to Negative, Absolute) and also to convert data formatted as 15.15- to -15.15 (That is the sign is on the right where it should be on the left)

                    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 →

                      Hi,

                      This is already supported. To convert signs,

                      1. Type -1 in a cell
                      2. Copy the cell that contains -1
                      3. Select the range you want to convert
                      3. On the Ribbon, choose Paste Special (or press Ctrl+Alt+V)
                      4. Choose Multiply

                      That will convert all numbers in the selected range to the opposite sign.

                      Cheers,
                      Dan [MS]

                    • Please add bold formula for some word in cell

                      when I type a sentence in a cell, I need one or several words in the sentence to bold because the word is important. I wish there was a formula to thicken the word that until now I have not found in the set of formulas excel.

                      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 →

                        If you are typing a sentence in a cell (that is, you have the actual text in the cell), you can select any word(s)/character(s) in that text and press the [B] button on the ribbon (or use Ctrl+B) to make that selection Bold (or apply other formatting).

                        Cheers,
                        Dan [MS]

                      • CTRL F shortcut in excel 2016 has been removed. Please can this shortcut be brought back.

                        CTRL F shortcut in excel 2016 has been removed. Please can this shortcut be brought back.

                        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

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

                          Hi,

                          Ctrl+F (Find) still exists in current buidls of Excel 2016. If you’re experiencing issues with it, please post the version of Excel (found under File > Office Account) you are using.

                          Thanks,
                          Dan [MS]

                        • Please return "Ctrl+{" or "Ctrl+[" to follow link (ref to precedent cell) used in formula!!!!!!

                          I'm a financial analyst and it's very hard to check big financial models with a lot of formulas and spend time of arrows.

                          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 →

                            Hi,

                            Ctrl+{a and Ctrl+[ should still work to follow dependencies (I just tried in the most recent version of Excel 2016).

                            Can you let me know what version of Excel you’re using where the behavior isn’t working anymore?

                            Cheers,
                            Dan [MS]

                          • The F4 function key

                            The F4 function key no longer insert the $ to lock in cell locations. 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

                              0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                            • There needs to be a "track changes" button like the one on Microsoft word.

                              Word has an icon and ability to track changes to your document. This needs to be installed on Excel instead of leaving comments. This makes it easy to work with when sending an excel document to other people.

                              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

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

                                There is already a track changes button on the Review tab of the ribbon (enable it by first selecting “share workbook”).

                                However, selecting this item does limit the types of changes you can make in your workbook, so you may find that it’s not as useful as you’d like.

                                Longer term, we want to build a system that tracks changes made by users via a service so that you can go back to any point in time in a spreadsheet’s life.

                                Cheers,
                                Dan [MS]

                              • I teach statistics why can't I have a "Mean" function.

                                It would be easier to type and would tie-into Stats language. This is so easy. A function labeled "MEAN".

                                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 →
                                • Allow VLookup to accept functions e.g. Max($B$1:$B$10)

                                  Allow VLookup/HLookup to accept functions e.g. MAX($B$1:$B$10) as the look up value. It currently returns #REF! whether using exact or approximate value.

                                  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

                                    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                  • CINT, CSTRING, CDOUBLE as Formulas

                                    You can do it in VBA, can we just have it as a formula to avoid txt to number drama.

                                    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 →

                                      We have these already in Excel. They are:
                                      =INT
                                      =TEXT
                                      =VALUE

                                      You may also want to take advantage of ISNONTEXT and ISNUMBER as you use these.

                                      cheers,
                                      Dan [MS]

                                    • Don't see your idea?

                                    Feedback and Knowledge Base