Select Page

Excel Video 317 is a collection of several tips from the Pivot Table Options Menu to make your life easier. The first tip is how to quickly remove all filters. Be careful to clear filters, not clear all. Clear all will clear your entire Pivot Table without an undo option! You can also clear all filters from the Data tab.
Watch for how to move a Pivot Table to a new location, how to turn off the Field List, and how to hide Row and Column Headers when you go to present your data. Finally, I’ll show you how to rename your Pivot Table. If you have several Pivot Tables in your spreadsheet and want to be sure you’re pulling data from the correct Pivot Table, this might help you.
Stay tuned. Next time we’ll look at other Pivot Table options in the options menu. Thanks for watching.