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. Tables should default to "My table has headers" being ticked

    It's taken me 10 years to realise this but I've never "unchecked" My Table has headers, it's ALWAYS the other way round, forgetting to remember to tick it because Excel hasn't recognised the header row.

    Let's default the tick to always on ?

    33 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

      6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    • Vertical Autofilter

      Excel allows you to use a horizontal autofilter, the same procedure could be applied to vertical autofilter.

      The procedure already exists in relation to the horizontal direction, the vertical's solution could be similar.

      Visual design may be the same, only the triangle should be rotated 90 degrees to the right.

      7 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
      • Filter Option - for 6 Months

        In Filter, there are options for Last Week, Month, Quarter & Year. There could be following 2 options that can help user a lot:
        1) Last 6 Months
        2) First 6 Months (Current Year)

        22 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
        • Ability to paste to filtered (visible) cells

          PROBLEM: Excel's PASTE (ctrl-V) operation does not distinguish between filtered and unfiltered cells, even though its COPY (ctrl-C) operation copies filtered (visible) cells.

          SOLUTIONS:
          * Enhance PASTE SPECIAL (ctrl-alt-V) to support the ability to paste into only filtered (visible) cells.
          * Add a user option to support this default PASTE action.

          BENEFITS:
          * Eliminates the danger of pasting into a filtered area without realizing the problem. This is a very common problem with users new to Excel. Even experienced users must be constantly aware of this problem.
          * Addresses a problem for which there is no good workaround. All VBA…

          21 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

            7 comments  ·  Tables, Sorting and Filtering  ·  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

              0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
            • Filtering back to start

              When using filters, I tend to filter data first to see what I have typed up, but need the data to return back to the order I typed it up originally. I think it would be a good idea to Unfilter the data, and it would return back to before any filter was applied. This is not the same as removing the filter, as the data does not go back to the way it was, but stays as the filtered 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

                0 comments  ·  Tables, Sorting and Filtering  ·  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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                • Table Headings and Subheadings

                  Hi

                  I have attached a file so you can have a better idea. There is a lot of things that are done manually in my spreadsheet that would be much more simple if Excel supported headings and subheadings.

                  I think that it should be much like the way it is done in Word. There should be the option for the different levels of headings (heading 1, heading 2, heading 3...just like Word and even OneNote.) When your filtering, you could then filter by heading.

                  I then think within the headings, you should be able to use a subtotal feature on…

                  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  ·  Tables, Sorting and Filtering  ·  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

                      0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                    • Make buttons with active filter also change color (red) so that they are easily seen.

                      With large tables and many columns the symbols for active filter is easily missed when columns are scrolled to find out in which column the filter is active. I suggest add color to active filter button (red). Also add item in table function to inactivate all filters with one click. That woud be great!

                      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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                      • Slicers are the best thing since...erm, Sliced Bread. In Power BI there is now the option to format Slicers as a Dropdown. Can this be broug

                        Slicers are the best thing since...erm, Sliced Bread.
                        In Power BI there is now the option to format Slicers as a Dropdown. Can this be brought into Excel also? It will save on real-estate on Report pages and Excel Dashboards.

                        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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                        • Search multiple entries when filtering

                          At the moment you have to search one entry at a time. When dealing with part numbers etc. For an example you could be trying to apply a formula to a total of 20/100 of them. This means having to type 20 different part numbers into the search box when filtering which takes forever. I suggest that there should be a multi entry search box that you can copy and paste into when filtering as this would save so much time.

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

                            I use the excel filter function a lot. Each time I click on filter, the filter box appears as a small box. I resize the box to show more entries, however when next selecting the filter, on any column, the box has returned to the default small size. Can Excel remember to keep the filter box to the size that I adjust it too.

                            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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                            • Remove Items From Selection option when filtering data

                              You have the option to add to selection when filtering data but there needs to be an option to remove from selection when filtering data. It took me 4 hours to figure out how to do this using Advanced Filtering.

                              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  ·  Tables, Sorting and Filtering  ·  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

                                  0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add an "invert selection" option to the filter drop-down

                                  Enable the user to invert their selection in the Filter drop-down. If I have a large table of data, I'd like to be able to de-select a few items in a filter, then use "invert selection" to switch the check box values of all items before applying the filter

                                  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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add a "Reset" button for working with a spreadsheet with Filters turned on.

                                    I often work with Excel sheets that have the Filter feature turned on and I think it would be great to have a "Reset" or "Filter Reset" button that would put all the filters a user creates back to original, meaning everything is turned on.

                                    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Advanced filter doesn’t recognise a table

                                      When you have made your data into a table , it does not allow you to use that table as the data range in the advanced filter, as it does not seem to recognise the top row and match it with the headings .

                                      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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Unhide a row by number

                                        I have a large spreadsheet with many hidden rows, hidden after performing various sorts and culling ranges of the sorted data. So the hidden rows are not necessarily contiguous. In a Find All search, I found a cell that met my needs, but it is in a hidden row. There is no way that I can find to unhide that row without unhiding a whole range of other non-contiguous rows that were hidden for differing reasons. I see several opportunities to make life easier for users. 1) An "unhide by row number" feature; 2) A context menu in the Find…

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

                                          Basic setup: a Table for keeping track of a simple loan to someone with one complication: the interest rate will change now and then.

                                          Basic need: it was set up to calculate and show Interest in one of the columns with the Interest Rate being stored as a Named Range (value) with a name like "Interest_2018_09_26" and each new interest rate would continue the idea with the formula in the Table being edited accordingly and it would fill in using the new version as one continued adding rows.

                                          Basic problem: No. The Table fills with the original formula, no matter…

                                          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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 12 13
                                          • Don't see your idea?

                                          Feedback and Knowledge Base