From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Selecting, clearing, moving, and copying

Selecting, clearing, moving, and copying - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial Buy for my team

Selecting, clearing, moving, and copying

“

- [Instructor] Let's talk about some of the simplest PivotTable Tools: selecting, clearing, moving, and copying Pivots. You can find these options in the Analyze tab under your PivotTable Tools. You can Clear, Select, and Move. So starting with your Clear options, you have two choices here. Clear All, essentially wipes your PivotTable clean, so any fields that you would drag to filters, rows, columns, or values will be completely removed. You won't be deleting any data; in fact, you won't even be deleting the link to your data. You're simply returning to a blank canvas as if you had just inserted a brand-new Pivot. On the other hand, Clear Filters will only affect fields with filters in place, so by clearing filters any field that's filtered will be reset to show all values so that your entire PivotTable will end up being automatically unfiltered. Next up you've got Select options. Now, if you're using certain table layouts, you can select individual components of your Pivot either…

Contents