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. 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)

    18 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

      9 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…

      13 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

        3 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 →
        • 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.

          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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
          • Being able to search activate to locate a spreadsheet tab in a way similar to filter and to also be able to sort them

            To be able to search Activate ( right click to the left of tabs) when locating a spreadsheet tab in a way similar to filter rather than having to page through the listing to find the one you want and to also be able to sort them. You could also select certain tabs for sheets you are working on to give easy access.

            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 →
            • Create Table Dialog Box

              It would be great if there was an additional field to add a table name on creation.

              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 →
              • export table as dxf for autocad or draftsight

                export table as dxf for autocad or draftsight

                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 →
                • Query RefreshStyles

                  given that pivot tables can have a varying number of columns as well as rows, we really need some way to control how they are added.
                  At present the control of rows is governed by QueryTable.RefreshStyle property but there are no xlCellinsertionMode constants which allow one to specify whether, when the number of columns change, (1) partial columns are added or deleted (2) full columns are added or deleted or (3) cells are overwritten.

                  This is really really necessary and I can't find a work-around.

                  Ideally, as pivot tables can expand both downwards and sideways, one should be able to…

                  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 →
                  • Excel prevents rows deletion when there are Excel tables (bug)

                    This is the situation: You have an Excel table in row 3 in sheet1 and another Excel table in row 3 in sheet2.
                    When you select both sheets and try to delete rows 1 and 2, expecting to be deleted in both sheets, Excel prevents the deletion (no messages). I think this is a bug because you can delete the rows when you do it only in one sheet at a 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 →
                    • Move “custom sort” to be a top level filter instead of nested under “sort by color”

                      Currently, the custom sort option is buried in “sort by color,” which does not make intuitive sense and forces an extra click every time one needs to edit/set up a custom sort. Please move this to be a top level filter just like sort A-Z

                      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 Reapply(Ctrl+Alt+L) work for Advanced Filter just as it works for Auto filters

                        Currently the feature Reapply (Ctrl+Alt+L) works only for Auto Filters.
                        Please make it work for Advanced Filters as well

                        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 →
                        • Swap option on filter

                          Filtering spreadsheet tables is a great option for quickly getting to the data you want to see, but how often have you scrolled down a long list to find the option you want only to realise you didn't deselect 'all' right up at the top?

                          How often do you select a group of options to look at the rows for it and then want to change to see everything except that group?

                          With a SWAP option on the filter box, possibly right mouse button activated, you could turn all the current ticks to blank, and all the current blanks to…

                          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

                            0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                          • Add currency data type to the new Data Types

                            Add Currencies to the new Data Types along with Stocks and Geography so we can get current exchange rates, symbols, etc. for various currencies.

                            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

                              2 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                            • Geography Data Types to Have logistics information

                              If we can incorporate the logistics information like
                              No of Seaports, Seaport Name, Average transit time from one city to another.

                              furthermore comparison of distance from one city to another that will be awesome for Supply Chain Guys like me to improve the business & take strategic decisions.

                              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 →
                              • Resize Table by double-click

                                Something, you have to resize the area of your table when you manually import or delete data in a Table.

                                Currently, you have 2 options to resize your Table:
                                - With the button Resize Table
                                - By drag and drop of the delimiter of the Table (it looks like a triangle) to adjust to the size of the data

                                My idea is to double-click on this Table delimiter to adjust automatically to the area of the data (rows and columns). This means that the table would automatically extend or contract to include new data or exclude empty rows/columns.

                                What do…

                                13 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 →
                                • 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Search option in Recent workbooks

                                    Can include "Recent Search" option in the "Recent Open" to make simpler way of finding recent opened files instead of scrolling up and down. Pls give feedback if it ok.

                                    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 →
                                    • Alphanumeric sorting

                                      Can't we sort things by number and letter at the same time? For instance 01, 02, 02a, 02ac, 03, 07, 07a, 07d, 08a51, 08a52, 08b11, 10b67a...
                                      you get the picture.

                                      Why are we locked in to only numbers listed first, and then numbers with letters?

                                      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  ·  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 →
                                        • Table names to show up in alphabetic order in Name Box

                                          The Name Box is really useful for navigating around spreadsheets but Table Names show up at the bottom of the list (if there are Range Names) and also appear in the order they are created rather than in alphabetic order. Not that helpful. Please include Table Names in the list in alphabetic order.

                                          8 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 →
                                          ← Previous 1 3 4 5 11 12
                                          • Don't see your idea?

                                          Feedback and Knowledge Base