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

Turn on Filtering for the Values Area of a Pivot Table

193 ratings | 40702 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 (57)
Ankush Mali (5 days ago)
Thanks it was really helpful
Doug H (4 days ago)
Thanks Ankush Mali, glad it helped!
Cruzznce (1 month ago)
I love you have my babies
Doug H (1 month ago)
K2 Get (1 month ago)
Dusmanta Choudhury (2 months ago)
Very helpful.Many thanks Doug.
Doug H (2 months ago)
Hi Dusmanta Choudhury...you're welcome, glad you liked!
Ni Ni Win (2 months ago)
Thank You, Very Helpful.
Doug H (2 months ago)
Thanks Ni Ni Win, glad it helped!
Mohit Singh (2 months 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 (2 months 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 (2 months ago)
Hi Manny M, thanks for the comment!😀
Anish Kumar (3 months 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 (3 months ago)
Hi Anish Kumar, glad you liked it, thanks for commenting!
Samsul Arefin (3 months ago)
Thanks .. It's really helpful.
Doug H (3 months ago)
Thanks Samsul Arefin, glad it helped!
André Pedrosa (4 months ago)
Thanks for the tip.
Doug H (4 months ago)
You're Welcome!
Richard Passett (5 months ago)
You're doing god's work
Doug H (5 months ago)
Hi Richard Passett, thanks for the kind words!
Armcannon (6 months ago)
Mega helpful. Thanks
Doug H (6 months ago)
Thanks Armcannon, glad it helped!
Erika Villa-Carlos (6 months ago)
Is there a way to filter where subtotals and grand totals are updated when filtered??
Dave Hollis (6 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 (6 months ago)
You're Welcome!
ujjc001 (7 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 (7 months ago)
Hi ujjc001, glad you liked it, thanks for commenting!
David Walker (8 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 (8 months ago)
Thank you! Solved a problem I've been struggling with forever!
Doug H (8 months ago)
Thanks Erin L Gardner, glad it helped!
Anand Venkat (9 months ago)
Amazing trick..thanks a ton!.
Doug H (9 months ago)
Hi Anand Venkat, glad you liked it, thanks for commenting!
Roman Angel (10 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 (10 months ago)
Thanks Roman Angel, glad it helped!
Sharad sharma (11 months ago)
Awesome video. Thanks a ton :)
Doug H (11 months ago)
you're welcome!
Jessica Tucker (11 months ago)
I can't freaking believe after all this time, it is that easy! You're a hero!
Doug H (10 months ago)
Thanks for the comment!
Harry Brown (10 months ago)
This absolutely made my day too!
Doug H (11 months ago)
Thanks for the comment!
Liz Heyer (11 months ago)
Exactly what I was looking for... thanks!
Doug H (11 months ago)
Hi Liz Heyer, glad you liked it, thanks for commenting!
Sarthak Gupta (11 months ago)
Doug H (11 months ago)
You're Welcome!
rochmarcbenoit (11 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 (11 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 (11 months ago)
I'm not sure what that means...I just generated a standard pivot table from raw data...
Doug H (11 months ago)
Maybe some of those values are strings not numbers....you may want to check.
Gaurav Kale (1 year 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.