Pivot Table Tips and Tricks

Add filter option for all your columns in a pivot table

Reading Time: 2 minutes

When you create a pivot table (TCD), 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 🧐

If you select the cell locate next to the header column of your pivot table

Select the cell next to the pivot table

In this situation, the menu Data > Filter is enabled

Filter is now enabled

And then, all your pivot table columns have the filter options 😍😍😍

All the columns have the filter option

With all the features related to filters

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

Related posts

Pivot Table Percentage

Frédéric LE GUEN

Calculation without equal

Frédéric LE GUEN

Compare 2 Columns

Frédéric LE GUEN

7 comments

Predrag 07/05/2021 at 10:01

such quick and simple solution, THANK YOU

Reply
jason 20/04/2021 at 16:32

Oh my god, i've been searching for a solution to this for dayssss. All these guides and tutorials and forum posts and NO ONE seems to address this. It's such an easy solution I'm laughing at myself lol. Thank you so much!

Reply
Frédéric LE GUEN 20/04/2021 at 17:06

I don't have time to promote my articles on forums. But you can do it 😉

Reply
Beverly Cusack 31/03/2021 at 17:18

simple and effective solution. Took 1 minute. Thank you

Reply
LM 24/02/2021 at 09:17

Excellent (and so misterious), thank you

Reply
Sandy Browner 05/11/2020 at 23:52

I have fought this FOREVER! Thanks!!

Reply
Julie R 27/08/2020 at 16:48

THANK YOU!!!

Reply

Leave a Comment