HomeОбразованиеRelated VideosMore From: Doug H

Turn on Filtering for the Values Area of a Pivot Table

164 ratings | 35026 views
Check out my Blog: http://exceltraining101.blogspot.com This video shows how to turn on filtering capabilities in the values area of a Pivot Table. When you create a Pivot Table you can sort and filter in the rows or column area but can only sort in the values area. There is a workaround that lets you turn on filtering in the values area. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Html code for embedding videos on your blog
Text Comments (50)
Ni Ni Win (8 hours ago)
Thank You, Very Helpful.
Doug H (8 hours ago)
Thanks Ni Ni Win, glad it helped!
Mohit Singh (4 days ago)
For some reason, when I try the shortcut, I'm still not being able to access the filter tool. Is there a reason/way to go around this problem?
Manny M (16 days ago)
From the bottom of my heart. I LOVE YOU. I was banging my head against the desk because I wanted to filter all the 0
Doug H (16 days ago)
Hi Manny M, thanks for the comment!😀
Anish Kumar (1 month ago)
Doug, just like many others here, I wanted to appreciate this video. I was already looking for ways to handle this, but this is simply awesome. Thanks for raising the awareness.
Doug H (1 month ago)
Hi Anish Kumar, glad you liked it, thanks for commenting!
Samsul Arefin (1 month ago)
Thanks .. It's really helpful.
Doug H (1 month ago)
Thanks Samsul Arefin, glad it helped!
André Pedrosa (2 months ago)
Thanks for the tip.
Doug H (2 months ago)
You're Welcome!
Richard Passett (3 months ago)
You're doing god's work
Doug H (3 months ago)
Hi Richard Passett, thanks for the kind words!
Armcannon (4 months ago)
Mega helpful. Thanks
Doug H (4 months ago)
Thanks Armcannon, glad it helped!
Erika Villa-Carlos (4 months ago)
Is there a way to filter where subtotals and grand totals are updated when filtered??
Dave Hollis (4 months ago)
Wow, that was a life saver. No matter what I searched on I could not turn up a solution on how to filter on the values column. Thanks!
Doug H (4 months ago)
You're Welcome!
ujjc001 (5 months ago)
This had just blown my mind and changed my life. I'm pretty savvy and always chalked this up to being impossible. BLOWN! I can't believe I've never thought of this!!! Thank you thank you thank you! If you live in the pivot table world every day you no doubt know how awesome this is!!!
Doug H (5 months ago)
Hi ujjc001, glad you liked it, thanks for commenting!
David Walker (6 months ago)
Love it! Works well and is easy, However, I filter data out, and it still shows up in my pivot chart. Is there a way to filter data in the values field, and not have these values included in it's chart?
Erin L Gardner (6 months ago)
Thank you! Solved a problem I've been struggling with forever!
Doug H (6 months ago)
Thanks Erin L Gardner, glad it helped!
Anand Venkat (7 months ago)
Amazing trick..thanks a ton!.
Doug H (7 months ago)
Hi Anand Venkat, glad you liked it, thanks for commenting!
Roman Angel (8 months ago)
YESSSSS!!!! Thank you!! Been racking my brain trying to figure this out and its that simple. UGH!!! Thank you!!! You're a life saver.
Doug H (8 months ago)
Thanks Roman Angel, glad it helped!
Sharad sharma (9 months ago)
Awesome video. Thanks a ton :)
Doug H (9 months ago)
you're welcome!
Jessica Tucker (9 months ago)
I can't freaking believe after all this time, it is that easy! You're a hero!
Doug H (8 months ago)
Thanks for the comment!
Harry Brown (8 months ago)
This absolutely made my day too!
Doug H (9 months ago)
Thanks for the comment!
Liz Heyer (9 months ago)
Exactly what I was looking for... thanks!
Doug H (9 months ago)
Hi Liz Heyer, glad you liked it, thanks for commenting!
Sarthak Gupta (9 months ago)
THANKYOU !!
Doug H (9 months ago)
You're Welcome!
rochmarcbenoit (9 months ago)
Hi, I keep trying to use value filters, but it isn't effective... nothing happens when I filter for top 10
Doug H (9 months ago)
take a look at your raw data...the values that are expected as numbers should be numerical values. A quick way to determine that is to look at the alignment. Say you have 123 in a cell. If it is aligned to the right, excel is treating it as a number (you can perform math operations on it). If it is aligned to the right, excel is seeing that value as string text even though it looks like a number. This videos explores some aspects of this https://www.youtube.com/watch?v=92DHgCfsAbA
rochmarcbenoit (9 months ago)
I'm not sure what that means...I just generated a standard pivot table from raw data...
Doug H (9 months ago)
Maybe some of those values are strings not numbers....you may want to check.
Gaurav Kale (10 months ago)
Wasn't this ability there in Excel 2003? In 2007 onwards you have to use this trick - clicking in the cell immediately to the right of the last title in the pivot table.
Dayna Westmoreland (1 year ago)
Thank you, thank you, thank you!! This is EXACTLY what we've been looking for.
Doug H (1 year ago)
Hi Dayna Westmoreland...you're welcome, glad you liked!
Brandon Wilkins (1 year ago)
Dude, you are fricking genius!!!  I've been scouring the web trying to find a way to filter my values column.  Several other "goo-roos" have all these steps and directions saying how simple it is, but their steps didn't work.  Yours was so simple and easy and most importantly, IT WORKED!  Thank you tremendously!!!
Doug H (1 year ago)
Hi Brandon Wilkins, glad you liked it, thanks for commenting!
Kalugampitiya Jayakody (2 years ago)
This is very informative video. Excellent. and thank you very much
Doug H (2 years ago)
Glad you liked, thanks for the comment!
Atul Singh (2 years ago)
thats awesome . can u help me to filter date in same analogy?
ExcelIsFun (2 years ago)
Great Tip!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.