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. Allow Sharepoint to be a "trusted" location and open files in edit mode by default.

    Even though I have sharepoint locations set up as a Trusted Locations, Excel will not default to opening those files in Edit mode. I have all of my frequent files pinned, and they all default to read-only mode when I open them. This means many many extra clicks every day as virtually everything I work on is located on sharepoint.

    4 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
    • Paste Special - add Append (&) to the Operation section (there is even space for it!)

      This would allow one to easily add text to the end of cells without having to create a new formula.

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

        It would be amazing if there were a button you could click when you had several cells highlighted, that would round them to a user specified number of decimal places. Similar to the =round(A1,2) function, but that would allow you to apply the "round" formula to several cells at once.

        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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
        • paste only unique entries

          Add to paste special... paste only unique records

          When a list is copied and this option selected, then duplicates are removed from the list before pasting.

          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

            1 comment  ·  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.

            49 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

              10 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
            • Hyperlink only certain text in one single cell

              Want to be able to hyperlink only a section of text in a cell. For example the cell would contain "For more information click here". Would like to make only the word "here" a hot link, not the entire text in the cell.

              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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
              • Change the CTRL + Z and CTRL + Y commands

                In the case of multiple open sheets the commands (CTRL + Z) and (CTRL + Y) work independently of the selected sheet. Perhaps it would be better for each sheet to take account of its own typing.

                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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                • Add 'change recorder' functionality that creates a change log to a workbook

                  Allow users to activate a change recorder for files (password protected to deactivate) that creates a log of changes, with date-time stamps and the users making the changes (similar to macro recorder?). The the log can be saved in the sheet, or sent to a specific location.

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

                    Move all the Protect Sheet options to a separate tab. At the moment, users can find some of the options on the Format tab but they have to go to Format Cells to find "Hidden". It's confusing.

                    It would also make it a lot clearer if the Lock Cell option had a clearer indication of whether it's on or off.

                    Users struggle to see if cells are locked or not.

                    4 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                    • I have a question? I have this on two computers. When I update on computer why doesn't it sync all computers.

                      It may be possible but I don't know how. I have excel on two computers. I have the same file. But when I input my expenses on one it doesn't update the other. Is there a way? If not there should be. It is the same account why wouldn't 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                      • Block invalid data when disabling data validation error

                        When using data validation, the user gets an error when entering invalid data, and is forced to change or cancel it. When disabling the error message, the user can enter invalid data and there is no forced change.
                        It would be helpful if there was an option to turn off the error, but still force the user to change the data in the cell, or automatically cancel and go back to the previous 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

                          0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                        • How about a hotkey for merging cells?

                          I would love a hotkey for merging cells as its really tedious when creating large tables to go through the entire document, pressing the button instead of hitting a key instead. Perhaps using the Ctrl function could achieve this?

                          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 →
                          • 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 →
                            • Allow Astrixs in Tab Names

                              I would like to use the * character in a tab name.

                              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

                                4 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                              • Enable user to enter a value (ideally multiple, too) to jump to an option in cell drop-down list (ALT + DOWN KEY)

                                When you are in a cell and press ALT + DOWN KEY, Excel will display a list of all of the values in that column. You have to scroll using the vertical scroll ball. It would nice to be able to enter the text that you're looking for and have Excel scroll to those values. Ideally with multiple characters allowed. And if you could uses the mouse scroll wheel (I have a Logitech hyperwheel) that would be beneficial as well.

                                4 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                • the window "Spelling" hides the window "Find and replace", causing a chain reaction of problems (Excel 2016, Windows 10)

                                  PROBLEM # 1:
                                  Spell check is not case sensitive: i.e. if there is a table, in the cells which are proper names written with the error case for the first letter, and the Name includes common words, whose register does not need to change (ie not the version of the formula into 1 cell or macro, because the word is obviously unknown), then when you check the spelling using the same editor (the most suitable in this case, the instrument) the word' are, because not known to the dictionary, but change the first letter from lowercase to uppercase is impossible…

                                  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 →
                                  • I would like to have a clear option as opposed to delete which leaves all the formatting in tack but gets rid of the data.

                                    I would like to have a clear option as opposed to delete which leaves all the formatting in tack but gets rid of the data

                                    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Enhance Insert Function dialog to support nested formulae

                                      In a recent youtube video,
                                      https://www.youtube.com/watch?v=HT6s2lGL5aY
                                      Bill Jelen discussed a way to work with the current dialog to make the Function Arguments dialog support a nested function. Thinking about this, Excel has over the years, made great strides in many many areas but the Insert Function and Function Arguments dialog has stood still.

                                      It could be upgraded to support nested functions - this is 2017 and there must be so many programming techniques to make this work.

                                      It would benefit beginners as well as advanced users and does not interfere / break the existing object model or vba.

                                      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 →
                                      • Remember the size of the Find dialog box when expanded for FInd All

                                        When the Find box in Excel is opened and FindAll is selected, the dialog box is never big enough to show the results. It should either:
                                        1) Expand to the size the user last selected, or
                                        2) Expand to hold all the results if they fit, else expand to 2/3 the screen height.

                                        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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Power Query/Get and Transform Shortcut Keys in the editor

                                          Keyboard shortcuts in the Power Query editor window would allow data to be quickly transformed without relying on the mouse. For example, to rename a column without a keyboard shortcut it requires multiple mouse clicks, and when there is a large dataset this can be quite a chore. Shortcuts would be a welcome addition!

                                          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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Feedback and Knowledge Base