I find there are times when you do need to start right again from scratch with a Pivot Table, but removing all of the column fields, row fields, data fields, filters etc can take time. Excel of course provides a really quick way to start over to get the job done quickly.
Here is where the magic Clear All option is our friend.
This button gives the option to Clear All or just Clear Filters.
The Clear All command will clear the whole Pivot Table without deleting the Pivot Table cache.
- Pivot Table Tools tab
- Options
- Clear All
The Clear Filters will clear the whole Pivot Table filters without deleting the Pivot Table cache.
- Pivot Table Tools tab
- Options
- Clear Filters
