Add filter option for all your pivot table columns

Add filter option for all your pivot table columns
Last Updated on 18/04/2024
Reading time: 2 minutes

How to add the filter option for all your Pivot Table columns? This article explains the trick and the technique

Only the first column has the filter option by default

When you create a pivot table, only the first column offers the option of filtering or sorting.

Default filter option in a Pivot Table

Now, if we want to add filters for the other columns, the Filter menu (Data > Filter) is disabled 😡😡😡

Impossible to apply the Filter

But there is a tips & tricks 🧐

Add a filter option for all your pivot table columns.

  1. Select the first empty cell after the header column of your pivot table
Select the cell next to the pivot table
  1. Click on the Filter menu Data > Filter (the menu is enabled)
Filter is now enabled
  1. And then, all your columns, have the filter option 😍😍😍
All the columns have the filter option

Now, for all the columns, you have all the filter options with all the features related to filters

  • Select specific values
  • Select larger / smaller than
  • Sort your data
All the filter option are available now

By filtering data in all the columns, users can narrow down the information they need and focus on relevant details.

This saves time and effort that would otherwise be spent manually sorting and sifting through data. Overall, filters make working with Excel more efficient and productive.

You can find more information about filters in the pivot table on the site of Microsoft

31 Comments

  1. Wraind
    01/11/2023 @ 22:15

    Click PivotTable Options
    Display Tab
    Put Check on Classic PivotTable layout

    hope this helps

    Reply

    • Frédéric LE GUEN
      02/11/2023 @ 03:07

      But it doesn't include the column Total. Only the column in the Row field

      Reply

  2. som
    20/06/2023 @ 08:32

    Thank you very much for the info. It helps.

    Reply

  3. Harith Khan
    23/05/2023 @ 03:54

    Thank you very much for this info!

    Reply

  4. fi
    06/04/2023 @ 07:08

    Thank you very much
    You saved my life

    Reply

    • Frédéric LE GUEN
      06/04/2023 @ 07:30

      You're welcome 🙂

      Reply

    • Sarah
      06/06/2023 @ 22:36

      Sending you massive THANK YOU THIS IS GENIUS!!!

      Reply

  5. Jude
    23/09/2022 @ 02:49

    Column filters still doesn't if work for the entire table. if you click the filter it doesn't make any change. Only first column filter works. Thank you.

    Reply

    • Frédéric LE GUEN
      23/09/2022 @ 12:53

      That's weird because it works for many years (what ever the Excel version)

      Reply

  6. Linnie
    12/09/2022 @ 07:58

    This is fantastic. Thanks for the tip.

    Reply

  7. Gina Dowling
    02/09/2022 @ 17:00

    I used to be able to do this in desktop excel all the time. Now i have excel 365 and this trick doesn't work. Any updated tips to help?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Add filter option for all your pivot table columns

Reading time: 2 minutes
Last Updated on 18/04/2024

How to add the filter option for all your Pivot Table columns? This article explains the trick and the technique

Only the first column has the filter option by default

When you create a pivot table, only the first column offers the option of filtering or sorting.

Default filter option in a Pivot Table

Now, if we want to add filters for the other columns, the Filter menu (Data > Filter) is disabled 😡😡😡

Impossible to apply the Filter

But there is a tips & tricks 🧐

Add a filter option for all your pivot table columns.

  1. Select the first empty cell after the header column of your pivot table
Select the cell next to the pivot table
  1. Click on the Filter menu Data > Filter (the menu is enabled)
Filter is now enabled
  1. And then, all your columns, have the filter option 😍😍😍
All the columns have the filter option

Now, for all the columns, you have all the filter options with all the features related to filters

  • Select specific values
  • Select larger / smaller than
  • Sort your data
All the filter option are available now

By filtering data in all the columns, users can narrow down the information they need and focus on relevant details.

This saves time and effort that would otherwise be spent manually sorting and sifting through data. Overall, filters make working with Excel more efficient and productive.

You can find more information about filters in the pivot table on the site of Microsoft

31 Comments

  1. Wraind
    01/11/2023 @ 22:15

    Click PivotTable Options
    Display Tab
    Put Check on Classic PivotTable layout

    hope this helps

    Reply

    • Frédéric LE GUEN
      02/11/2023 @ 03:07

      But it doesn't include the column Total. Only the column in the Row field

      Reply

  2. som
    20/06/2023 @ 08:32

    Thank you very much for the info. It helps.

    Reply

  3. Harith Khan
    23/05/2023 @ 03:54

    Thank you very much for this info!

    Reply

  4. fi
    06/04/2023 @ 07:08

    Thank you very much
    You saved my life

    Reply

    • Frédéric LE GUEN
      06/04/2023 @ 07:30

      You're welcome 🙂

      Reply

    • Sarah
      06/06/2023 @ 22:36

      Sending you massive THANK YOU THIS IS GENIUS!!!

      Reply

  5. Jude
    23/09/2022 @ 02:49

    Column filters still doesn't if work for the entire table. if you click the filter it doesn't make any change. Only first column filter works. Thank you.

    Reply

    • Frédéric LE GUEN
      23/09/2022 @ 12:53

      That's weird because it works for many years (what ever the Excel version)

      Reply

  6. Linnie
    12/09/2022 @ 07:58

    This is fantastic. Thanks for the tip.

    Reply

  7. Gina Dowling
    02/09/2022 @ 17:00

    I used to be able to do this in desktop excel all the time. Now i have excel 365 and this trick doesn't work. Any updated tips to help?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *