From the course: Excel: PivotTables in Depth

Unlock the full course today

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

Configure a PivotTable

Configure a PivotTable

From the course: Excel: PivotTables in Depth

Start my 1-month free trial Buy for my team

Configure a PivotTable

“

- [Instructor] When you create a PivotTable, Excel shows the number of PivotTable elements by default. You can show, hide or, in some cases, move those elements to change the PivotTable configuration to your liking. In this movie, I will use the sample file 01_05 Configure to demonstrate some of these techniques. When you work with a PivotTable, you want to ensure that you have a cell within the PivotTable selected. So I currently have row labels at O3 selected. Aand if I click in the body of the PivotTable, then I see the contextual tabs on the ribbon, and then also the PivotTable Fields task pane. If I click away from the PivotTable, then those elements go away. And of course, if I click back, then they return. Most of the tools that we will use in this movie are found on the PivotTable Analyze contextual tab, so I'll click that. And over on the right, we have the PivotTable Fields task pane. Above that, in the Show group, we have buttons for Field List, +/- or Show/Hide buttons…

Contents