Look Who it Was Random video

Excel - Unlock the Power of Pivot Tables: Excel 2003 AutoFilter Hack Revealed! - Episode 793

2,685 views · Published 15 January 2009 · 3:12 · Indexed 4 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Unlock the Power of Pivot Tables: Excel AutoFilter Hack Revealed!

Welcome back to the MrExcel netcast! I'm Bill Jelen and I have an exciting new trick to share with you today. During my recent spring seminar season, a member of the audience showed me a clever hack for filtering pivot tables. I was blown away and knew I had to share it with all of you.

Have you ever tried to filter a pivot table in Excel 2003 and found that the option is grayed out? Well, thanks to Dan from Philadelphia, we now have a workaround for this issue. Simply start in the cell next to the heading rows (in this case, cell G4), hold down the SHIFT key, and use the arrow keys to select all the headings. Then, go to DATA, FILTER, and voila - AUTOFILTER is now available!

This hack allows you to create any kind of filter you want for your pivot table. For example, you can filter by a specific profit amount, such as ＞ $50,000. And the best part? You can still see the grand total for all the data, unlike the traditional method of using the TOP 10 AUTOSHOW feature. This trick is a game-changer for anyone who works with pivot tables on a regular basis.

I want to give a special shoutout to Dan from Philly for sharing this amazing tip with us. Remember, the key is to start outside of the pivot table when creating the filter. And when you want to turn off the filter, simply use DATA, FILTER, AUTOFILTER from the extra cell outside of the pivot table.

I hope you found this hack as useful as I did. Don't forget to subscribe to our channel for more Excel tips and tricks. Thanks for watching and we'll see you next time for another netcast from MrExcel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Normally, you can not use AutoFilter within a pivot table. Today, Dan from Philly shares an amazing hack that allows you to filter the results of the pivot table. Episode 793 shows you how.

Table of Contents:
(00:00) Introduction to the MrExcel netcast
(00:14) Recap of the spring seminar season
(00:24) A new trick for filtering pivot tables
(00:38) Excel 2003 limitations with filtering
(00:48) Workaround for filtering in pivot tables
(01:02) Using the AUTOFILTER feature
(01:12) Creating custom filters in pivot tables
(01:27) Returning to the original data set
(01:37) Showing top customers in pivot tables
(01:50) Alternative method for showing top customers
(02:25) Thanking Dan for the trick
(02:36) Turning off the AUTOFILTER feature
(02:51) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Advanced filter in Excel pivot table
Clearing autofilter in Excel pivot table
Creating filters in Excel pivot table
Excel 2003 autofilter grayed out
Excel pivot table custom filter
Excel pivot table filter
Filtering pivot table by profit
Filtering pivot table by revenue
How to filter data in Excel pivot table
Show total for all customers in Excel pivot table
Top 10 customers in Excel pivot table


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152090/

More from this channel