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. Stop Excel from changing large "numbers" (actually text values) to scientific notation.

    Prevent Excel from changing large "numbers" (actually text values) to scientific notation.

    582 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

      147 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

      Thanks for the post Caleb. As some folks in the comments mention, you can change the format of the cell to Text before the paste. But even so, it’s clear that there’s some user pain around this experience. We hear you and we’ll evaluate how we can do a better job here. As always, we’ll spend the most time/attention on the things with the most votes, so please keep voting for things you want the most.

      Best,
      John [MS XL]

    • Maintain leading zeroes when entering values in cells

      There should be an application setting OR paste recovery option OR cell format to retain leading zeroes when entering values in cells (either manually or through another means like CSV import).

      (2015-11-05 Dan [MS] Updated idea title and description to broaden this issue from maintaining leading zeros on CSV data import to maintaining them on any cell entry.)

      490 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

        36 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

        Thanks for the post – and thanks to all those that are speaking with their votes – we’re listening. I’ll get someone on the team to take a look at this. As always, keep voting for things that matter to you – the things with the most votes will tend to get prioritized higher on our side.

        Thanks,
        John [MS XL]

      • Add icons for font superscript and subscript so we can put them on the QAT

        Word has direct access (with icons) on the ribbon for subscripting and superscripting characters, but Excel can do so only via the Home...Font menu item. Scientists and engineers need to use subscript and superscript characters when writing mathematical and chemical formulas. Please copy the subscript and superscript icons in Word, and make them available to the Customize QAT feature.

        342 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

          55 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

          Thanks for the suggestion Brad – great idea and it’s also one we’ve heard from some of our student users. We’ll take a look at the issue. Please keep voting up the things that are most important!

          Thanks,
          John [MS XL]

        • Make Undo stacks track per workbook instead of globally

          Undo stacks are currently global between all workbooks that are open at a given time, so pressing undo on one workbook might undo a change in a different workbook. As someone who frequently has multiple workbooks open at a time, it would be much more helpful to be able to step through the edits made on each individual workbook.

          290 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

            23 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
          • Maintain copied data on the clipboard even if the "dancing ants" aren't shown around the copied range (Copy-paste clipboard persistence)

            If I copy [ctrl-c] a cell, then type in another cell, then try pasting, no result. No paste. It would be nice if Excel would maintain the copied data on the clipboard even after the dancing ants no longer appeared, so that I could paste that data.

            (2015-11-05 Dan [MS] - updated idea title and description to be clearer)

            211 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

              24 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

              Thanks for the feedback and suggestion Jamie8848 – we’re listening. I posted a comment as well, and welcome people pile on/suggest cases they care more/less about (as some others are doing in this thread already). We’ll keep an eye on this one, particularly since it seems to be making its way up the charts. I encourage people to keep voting for it if they want to see this behavior changed.

              Thanks,
              John [MS XL]

            • Unselecting cells when using Ctrl to select multiple cells

              When using Ctrl to select multiple cells, we can't unselect a cell when it was misclicked. Instead, we have to click these cells all over again. Please allow us to unselect cells!

              205 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

                8 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

                Thanks for the suggestion. We generally try to prioritize things according to the number of votes they get – so please be sure to vote for things you want to see done sooner.

                Thanks,
                John [MS XL]

              • IP Address as a datatype.

                I would love to see IP Addresses added as a format option and functions added for validation of the IP addresses..

                For instance InSubnet(Network as IP,Netmask as Integer,address as IP) to determine if an IP is within a Subnet;

                Being able to do addition/subtraction on the field would be awesome as well!

                167 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

                  22 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

                  Thanks for the suggestion Alex, and thanks to those that making their vote heard. This is a pretty interesting ask – take a look at the comment I made. I’d like us to understand a few related things. And as always, please keep voting for the things you care about most.

                  Cheers,
                  John [MS XL]

                • Allow us to turn off automatic conversion to date

                  Search for "make excel stop converting numbers to dates" and you will see the user demand for this feature. Please for the love of all that is holy let this be at least an advanced user setting.

                  119 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

                    16 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

                    Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!

                    Cheers,
                    John [MS XL]

                  • Be able to protect Power Pivot data model and measures with password

                    When you create a data model and measures in PowerPivot with PRO versions, users can modify and edit both.

                    Users and customers that have no idea on how the model has been build can make a lot of damage and dysfunction.

                    As well as VBA has it would be very interesting that Power Pivot has the option to be able to protect data model and measures with a password.

                    78 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                    • Fill Handle For Worksheet Copy

                      If I have a worksheet called January and I Ctrl+Drag that sheet to make a copy, Excel should automatically call it February. Use the same logic as the Fill Handle (support months, weekdays, and any custom list).

                      74 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                      • Paste Special - Add a numeric field when using one operation

                        Via the Paste Special we can operate on a range of values. However, to do, for instance, a multiplication, we first need to use a cell for it. As an option I would like to see that we can instead add a number to the Paste Special dialog as the attached screen shot shows.

                        41 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                        • Protect me from #REF! ambushes

                          Every so often I delete cells and unbeknownst to me create a bunch of #REF! errors in another part of my worksheet. I may not realize until much later when I can no longer undo back to fix the error. Excel could spare me this. If my deletion is about to create #REF!s it should bring up an alert like "Other cells depend on the cells you are about to delete. Would you like Excel to adjust their formulas to avoid #REF! errors? [Yes][No][Cancel]. [No] would do what it does today. [Cancel] would abort the operation. [Yes] would smartly substitute…

                          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

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

                            Thanks to RH for posting this suggestion. If avoiding #REF! errors is important to you also, please add your vote to support RH’s suggestion. We will prioritize accordingly.

                            Thanks,
                            Steve (MS Excel)

                          • Give user option to NOT take selected/all Defined Names to new workbook when copying worksheet

                            If you copy a worksheet from one workbook to another, Excel currently also automatically copies ALL Defined Names (even if there is no range in the source workbook to which these refer!). It will also copy without warning names with a different scope to an existing name in the target workbook (i.e. If an existing name has Workbook scope, a copied Sheet scoped name will be copied without an warning of the duplication!). This can result in a huge number of redundant or conflicting Names in the target workbook.

                            27 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                            • Prominent Manual Calculation Mode warning

                              Given the great danger of not realising that calculation mode is set to Manual, it would be very beneficial if a "Manual Calculation Mode" indicator (in bright fire-engine red!) was displayed (and visibility maintained until calc mode is switched back to non-manual) in a prominent location - such as in the Title Bar to the left of the Minimize button.

                              22 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                              • Use General format when inserting a new column instead of inheriting the format of the previous one.

                                Use Genral format when inserting a new column instead of inheriting the format of the previous one. Or ask the user.

                                16 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

                                  5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                • The ability to copy (or paste) 'visible cells only' when copying/pasting from a filtered range into a column of empty cells

                                  An example is the following scenario:

                                  If I use a filter on a column and remove blanks, only listing the cells with data. I then copy this data (visible cells only) and wish to paste this data into a filtered column of blank cells.

                                  Currently Excel pastes this data into the unfiltered cells. It would be a great addition if Excel would allow users to paste in the filtered list that was visible only with the filter applied.

                                  It is possible to get round this using a macro but I feel it should be part of a feature within Excel…

                                  15 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

                                    5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Change Excel's paste default behavior

                                    When you do an ordinary paste like Ctrl+V, Excel pastes the cell values, formatting, validation, everything. However, many users usually paste only values when working, and the extra handling to paste special is not productive.
                                    Word and OneNote have a setting that allow the user to choose the default paste type, and that should also be available in Excel.
                                    -
                                    I know there are add-ins to workaround that and also the shortcut AppKey+V to paste values, but I think that should be a native Excel setting.

                                    15 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

                                      4 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Allow Excel ‘Paste Special’ to operate on ‘Cut’ data as well as ‘Copied’ data

                                      When entering one of a few columns of data into a spreadsheet, I missed one number, so entered the others one row too high. To avoid re-entering all of the latter numbers, I tried to ‘Cut’ and use ‘Paste Special’ to move all the values down one row. (A simple ‘Cut’ and ‘Paste’ would have moved the references as well, achieving nothing except misaligning the rows.) After several frustrating attempts, I realized that I could only use ‘Paste Special’ if I ‘Copied’ the cells rather than ‘Cut’ them. Unlike cutting, this left the topmost incorrect cell with its value unchanged,…

                                      13 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

                                        4 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Swap rows / columns / ranges (Paste Special > Swap, for instance)

                                        a 'Swap' function (as a right-click) could allow data in specific cells or ranges to be swapped. Without it, users need to find or create an interim sheet / cell, which is a pain. I'd like this to work like the existing Paste-transpose function.

                                        12 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

                                          4 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Linked Transpose Paste

                                          You can copy and paste special by linking or transposing, but you can't do both. Please fix

                                          12 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 8 9
                                          • Don't see your idea?

                                          Feedback and Knowledge Base