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. Reduce the wasted space above the spreadsheet!

    Reduce the wasted space in the spreadsheet. Referring to the ribbons and spaces above the actual spreadsheet. Especially when viewing multiple files in horizontal arrangement, where there are groupings, the actual viewable spreadsheet real estate is tiny. Very annoying and unproductive having to constant scroll up/down the multiple files. In the past, it was possible to lessen the wasted space but somehow with the new ribbon design, you forgot why people use spreadsheets in the first place, which is to look at data not view the scenary.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    • 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 →
          • I would like to have the option of deleting a document (i am just learning the how to do it and I haven't found a way yet).

            I would like to have the option of deleting a document (i am just learning the how to do it and I haven't found a way yet).

            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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

              To delete a document, simply select the file in Windows Explorer (or SharePoint Online or OneDrive – wherever the file is stored) and press the delete key on your keyboard.

              Hope that helps,
              Dan [MS]

            • Bring back parentheses for negative number formatting

              Bring back parentheses for negative number formatting as in previous excel versions

              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

                3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                Using parentheses for negative number formatting is still supported by Excel (just like in previous versions).

                To use it:
                1. Select the cells/range you want to use parentheses when negative.
                2. Press Ctrl+1 to bring up the Format Cells dialog (or on the Ribbon, click on the Number format drop down, then select “More Number Formats…”)
                3. On the Number tab of the Format Cells dialog, select the Number category, and then one of the number formats that uses parentheses for negative numbers.

                Cheers,
                Dan [MS]

              • New Shortcut to copy the content from previous cell (in the same row)

                For a long time we have Ctrl+d to copy the content from previous cell from the same column, it would be great if we have a similar key to copy the content from the previous cell in the same row

                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  ·  Editing  ·  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

                    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

                    This is already supported in Excel 2010 and later when using PivotTables based on data from Analysis Services (or other write-back enabled OLAP providers).

                    Cheers,
                    Dan [MS]

                  • 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                      Hi,

                      This is already supported in Excel. To clear a print area
                      1. Click anywhere on the worksheet for which you want to clear the print area.
                      2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.

                      You can see these steps here: https://support.office.com/en-us/article/define-or-clear-a-print-area-on-a-worksheet-2e5992fa-f201-41a1-9f39-370ff14deca1?ui=en-US&rs=en-US&ad=US#bmclearprintarea

                      You can see this visualized here: http://www.solveyourtech.com/how-clear-print-area-excel-2010/

                      Cheers,
                      Dan [MS]

                    • Allow saving filters

                      As a biz user, we filter sheets all the time ... and very often run through switching filters repeatedly. I mean that given a multiple columns, we might filter a few columns to see what the data says then someone else using the sheet may filter differently, and then we want to return to the original set of filters.

                      The feature request is to save a snapshot of the filter choices with a name, so that users can prepare several combinations of filters and switch between them easily.

                      This is particularly useful when the underlying data changes.

                      Essentially, as a…

                      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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

                        Hi Rivan,

                        If you are using AutoFilters for your filters, check out “Custom Views” which are accessible on the View ribbon, and allow you to save your filter settings.

                        Cheers,
                        Dan [MS]

                      • Protect some cells so that it dosn't accidently change by typing

                        Some cells contain data that are final and should not change by accidently pressing a key, for example student's marks in exam.
                        after entering such data I would like to be able to protect some cells, and I can unprotect later if I want. like in drawing applications you can lock a shape or layer

                        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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                        • In Excel, when I had to change a word or a number, at the top of the sheet, I could do it, now I have to retype everything in the cell

                          Fix Excel, so when you have to change a word, number or sentence within a cell you can do it without retyping all the information in the cell. I used to be able to do it, but it is no longer possible.

                          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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

                            This is still possible.

                            1. Select the cell
                            2. Select the part of the content you want to change in the formula bar (above the grid)
                            3. Change that part of the content and hit

                            Hope that helps,
                            Dan [MS]

                          • auto border

                            An automatic function that would put borders in your table in an automatic way.

                            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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                              You can do this a couple ways -

                              1. If you apply a table style that has a border, you’ll get a border on your tables

                              2. You can take #1 a step further by defining a table style (or customizing an existing one) to have a border you like, and then you can set that table style as the default table style.

                              Of course, you can also add a border around your table using the border button on the ribbon too (but it’s not automatic, and takes two clicks per table).

                              Cheers,
                              Dan [MS]

                            • Fix problem where formulas display rather than their results, when this option has not been selected.

                              Every now and then a formula displays rather than the result of the formula. I realize there is an option for this; however; on occasion it happens to a particular cell or range of cells when this option has not been selected. The rest of the worksheet functions properly. This has been an ongoing problem for years.

                              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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

                                Hi, This happens when a cell is formatted as Text prior to entering a formula. Since formatting a cell as text is an explicit operation, Excel doesn’t “automatically change that formatting” when you enter a formula.

                                Cheers,
                                Dan [MS]

                              • Add gradient fill as a cell fill option

                                The ability to fill a range of cells with a gradient color would allow for a greater level of creativity and a professional polished finished product.

                                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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                                  One and Two color gradient fills are already supported. To add one,

                                  1. Select the cell you want to fill
                                  2. Press Ctrl+1 to bring up the Format Cell dialog
                                  3. Click on the Fill tab, then “Fill Effects…”

                                  Now you can create your gradient.

                                  Hope that helps,
                                  Dan [MS]

                                • New spreadsheets should only have a single sheet

                                  The normal thing is to only want one sheet. If I want multiple sheets I would normally want more than 3. It is easier to add a new sheet than delete one you don't want. Also many of the formats you can save a workbook in don't support multiple sheets. As such I think it would be more user friendly to only have the one tab to start with.

                                  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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

                                    Hi Martin,

                                    Excel versions starting with either 2007 or 2010 (I forget exactly) now have only one sheet by default, as we came to the same conclusion that you did.

                                    Also, as Kenneth mentions, you can change this value here: File → Options → General → When creating new workbooks → Include this many sheets.

                                    Hope that helps,
                                    Dan [MS]

                                  • a new hotkey for copy cell values

                                    we need a hotkey for copy cell values. ctrl+c copies cell. but usually we need to copy the "text" or "number" that stored in the cell.

                                    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                                      Hi Setan,

                                      Good news – This is already supported in Excel, but it’s done as part of Paste, rather than as part of Copy.

                                      1. Select the range you want to copy values from
                                      2. Ctrl+C
                                      3. Select where you want to Paste
                                      4. Ctrl+Alt+V (Paste Special)
                                      5. Choose “Values”

                                      The reason we do this is so that you don’t need to make the decision about what you want to paste until you actually do the paste operation, and you can paste several different things with one copy operation (you could paste values and formatting for example).

                                      Hope that helps,
                                      Dan [MS]

                                    • 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  ·  Flag idea as inappropriate…  ·  Admin →

                                        This is already supported in Excel. All you need to do is put an equal sign before the numbers you want to calculate. So, if you do =15.95/.79, you’ll get the result of that calculation in the cell.

                                        Hope that helps,
                                        Dan [MS]

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

                                        • I think the default way to format a time should be HH:MM:SS.000

                                          Currently the default time format is MM:SS.0 which I don't find helpful because I don't know which hour the time is from. Alternatively we should able to set a default time format for Excel

                                          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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                                            The default time format is taken from your system time format. In US English, it is h:mm:ss AM/PM

                                            (actually it is [$-x-systime]h:mm:ss AM/PM)

                                            Cheers,
                                            Dan [MS]

                                          • Don't see your idea?

                                          Feedback and Knowledge Base