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

Fill Series

Frédéric LE GUEN

Extract sample randomly in Excel

Frédéric LE GUEN

How to become Office Insider

Frédéric LE GUEN


Ruchika 19/01/2022 at 20:40

I have date field which I want to use as filter in pivottable report. But i see only dates, i want to have multiple filters in same dropdown for year,month, quarter,day . Please share how to achieve that.

Frédéric LE GUEN 19/01/2022 at 20:56

Very good question. Tomorrow I will do an article or video for that

Vivek 15/01/2022 at 12:43

thanks for the great tip.

Now, I'm trying to figure out how to see the value filter just below the Number filters in the right-click menu, and I dont see in it my Pivot.

I have downloaded a sample excel with a pivot which already has the value filter. I'm trying to create my own pivot in this sample excel using the same data set, but I just dont see the value filer.

can someone help?

Yusely Palacios 13/10/2021 at 01:25

Thank you, I was going crazy looking for a way to do this.

Eric Meunier 20/09/2021 at 13:22

it works when I have one set of values, but with 2 sets, I can't get the filter across the whole pivot table. Note that it used to work with 2016 but since my recent 'upgrade' to 365, this feature seems to be lost.

Frédéric LE GUEN 28/09/2021 at 13:49

True it works only with 1 header not 2.
But it works also with 365. That's what I use

Joy 09/09/2021 at 07:56

wow, thank you! great help! =)

Frédéric LE GUEN 09/09/2021 at 08:10

You're welcome

Andreas 06/08/2021 at 09:10

Wow, so simple! Thank you!

Frédéric LE GUEN 19/08/2021 at 07:03

You're welcome 😉

Prajjwal Agrawal 13/07/2021 at 12:51


Predrag 07/05/2021 at 10:01

such quick and simple solution, THANK YOU

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!

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 😉

Beverly Cusack 31/03/2021 at 17:18

simple and effective solution. Took 1 minute. Thank you

LM 24/02/2021 at 09:17

Excellent (and so misterious), thank you

Sandy Browner 05/11/2020 at 23:52

I have fought this FOREVER! Thanks!!

Julie R 27/08/2020 at 16:48



Leave a Comment