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. Get Tables working on protected sheets (add rows, sort, filter, etc.)

    I would like to be able to, under the right circumstances, have the ability to add/remove rows of a table which resides on a protected sheet.

    Currently if you protect a sheet you can't insert/delete rows of a table. Even if you unprotect all cells and allow inserting/deleting of rows on sheet protection, it doesn't matter and is completely ignored.

    What I am proposing would have to follow specific rules:

    * Table cells would have to be unprotected
    * Cells below table would have to be unprotected (truly optional † )
    * Insert Rows would have to be specified in…

    113 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

      35 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    • Use F4 key to lock reference in a table

      When you create formula with the named range of a table, you can't easily block the reference of your column.

      For instance, if you used the fill-handle to copy to the right, the reference of your column will change :( The only way to avoid that is to write [[column1]:[column1]] for all your reference (very annoying)

      So my suggestion to block the reference of a named range is to use the F4 key.
      Your formula is =SUM(table1[column1]) and after pressing F4 it becomes =SUM(table1[[column1]:[column1]])

      63 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

        11 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

        Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

        Best,
        John [MS XL]

      • Enable Merged Cell Sorting

        For rows or columns that contain merged cells, all rows or columns associated with the merged cells should be treated and sorted as 1 row or column.

        30 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

          6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
        • Filter columns by more than one color

          I would like to filter columns by color, one color is ok and works fine, but choose two or more colours in the same filter

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

            Have a Control with the most recent filters (last 5 to 10 filters), so the filters can be reapplied to an existing table.

            This should enable power users to work faster and Archive more in Excel.

            18 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
            • Pin the (Select All) check box in a filter list

              The (Select All) check box appears first in a filter list but disappears when you scroll down the list. I would prefer to see this box pinned at the top of the list so it can be checked and unchecked easily however far down the list you scroll. I often scroll down a long list then realise I wanted to deselect all and just choose one option so I have to scroll all the way back up to unchecked the box.

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

                1) Please add a functionality to "invert selection". Often you want to filter a couple of lines and after that check the remainder. It would be nice to have a one-click-solution for that.
                2) Please add functionality to "filter from cliboard". If you want to filter by various attributes you should be able to copy them from your list and add the copied lines to the filter.

                14 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                • Marking values presented more that once in filter window

                  While working with purchase specifications, the same positions in differens rows often appear with different quantities in each row which should be summed up for sending a request. It would be very convenient to have values corresponding with more then one rows marked by font, color, etc. in filter window…

                  14 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

                    6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                  • Data validation - allow Table references as List Source.

                    If I'm using Data Validation in List mode, and I use a Table reference (e.g. "=Table1[Column1]") as the source, for some reason it doesn't work!

                    The workaround is to create a separate named range for that Table reference (e.g. make a named range called "Table1Column1" that Refers to "=Table1[Column1]", but it's a real pain to have to do this every time, and it is something that I use a lot!

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

                      This feature should allow you to create, name, and save custom views of data that can be selected without affecting how other users see it.
                      As a next step it would be handy to share specific filter views with other users and choose which specific filter view should be applied by default.

                      Similar request already planned for Excel Online:
                      https://excel.uservoice.com/forums/274580-excel-online/suggestions/8192445-allow-for-personal-user-views-filters

                      Example of how it is done with filter views in G Sheets (available for a couple of years by now): https://www.youtube.com/watch?v=Noue5sB69Uc

                      9 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                      • Change Excel Table Name in the Create Table Window

                        Every time I Insert an Excel Table I then have to go change the Table Name (Alt+J,T,A). It would be great if the Table Name could be changed on the Create Table window when you are selecting the range of the Table.

                        It would also be nice to have some default settings for the table names. For example, I prefix all my table names with "tbl". This makes it a lot easier to get a list of the tables in the workbook when writing formulas. I would like to store this preference somewhere and then have the table name be…

                        9 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                        • Filtering - Why does it snap back to A1?

                          When turning on filtering in a worksheet, you are automatically snapped back to A1. Typically, I turn on filtering near the column I want to filter. It's more time consuming to be at the column I want to filter and then be snapped back to the beginning, only to be left looking for that column again. Can we have the ability to turn on filtering without the snap back to A1? Thanks!

                          8 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                          • Move (Blanks) to the top of the Filter

                            Hello,

                            Currently, the (Blanks) checkbox is at the very bottom of the Filter dropdown. Please move (Blanks) to the top. I uncheck (Blanks) all of the time, so it would be quite convenient. Thank you for your consideration.

                            7 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                            • primary key for rows in a table

                              I'd love to have an option in a table to add an ID (record counter) field. No formulas or vba just a system generated unique number for each new row in a table. Automatic timestamp would be great too! vba could do this but making it a built-in feature would be helpful for those who want to keep it simple.

                              5 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                              • Advanced Filter to copy to another worksheet/tab

                                When performing an Advanced Filter and Copying to Another Location, you cannot extract the data to another worksheet. You have to perform the operation on the same sheet as the data. It would be nice to export the advance filtered data to another worksheet or even workbook! Many a time, I have to send that extraction to someone else as an email attachment.

                                4 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                • Enable mouse scroll after opening Filter drop down menu

                                  Session: Enable filter on a large amount of data. Select drop down menu (presumes that the entries in the drop down menu require scrolling to view). Mouse wheel scroll. Nothing happens (FAIL).

                                  Expectation: After opening filter drop down menu, the application should be aware of mouse location and enable scrolling immediately.

                                  Note: User can click inside the menu (carefully as to not select something, or select then deselect), and then mouse wheel scroll functions. It should be smarter.

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

                                    1) Bug: when panes are frozen, in the moment when filter is applied the sheet is being violently scrolled horizontally in a random direction, hiding the active column.
                                    Please do not scroll on filter application.

                                    2) Missing functionality: The filter popup list can be re-sized to show more or wider items. Unfortunately the size of the popup is not remembered on the next pop.

                                    Many thanks!

                                    4 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Dynamic headings or additional header rows in tables

                                      This is somewhat related to
                                      https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9647427-header-selection-while-sorting

                                      I believe that table column headings should be dynamic (i.e. value determined by a formula), and if that's not possible, then we should at least be able to specify an arbitrary number of dynamic "subheadings". There are times that you have non-heading information that you want to put at the top of a table without having it as part of the heading. Examples include small notes or units.

                                      A common approach that I take in tables is to have the user choose a unit to be put in the CONVERT function. That way, I…

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

                                        This function would allow a user to highlight a column and sort it randomly. Meaning the values in a column would appear in a random order after this sort is applied.

                                        3 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Table cells cannot be merged.

                                          You have to convert the table into a normal range of cells in order to merge cells.

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

                                          Feedback and Knowledge Base