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.
Now, if we want to add filters for the other columns, the Filter menu (Data > Filter) is disabled 😡😡😡
But there is a tips & tricks 🧐
Add a filter option for all your pivot table columns.
- Select the first empty cell after the header column of your pivot table
- Click on the Filter menu Data > Filter (the menu is enabled)
- And then, all your pivot table 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
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
Harith Khan
fi
Frédéric LE GUEN
Sarah
Jude
Linnie
Gina Dowling
23/05/2023 @ 03:54
Thank you very much for this info!
06/04/2023 @ 07:08
Thank you very much
You saved my life
06/04/2023 @ 07:30
You're welcome 🙂
06/06/2023 @ 22:36
Sending you massive THANK YOU THIS IS GENIUS!!!
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.
23/09/2022 @ 12:53
That's weird because it works for many years (what ever the Excel version)
12/09/2022 @ 07:58
This is fantastic. Thanks for the tip.
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?