Configuring a PivotTable


show more Configuring a PivotTable provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Configuring a PivotTable

Then you create a PivotTable in Excel Excel shows the number of PivotTable elements by default. You can show, hide, or in some cases move these elements to change the PivotTable configuration to your liking. For example one element of the PivotTable that's associated with the Ribbon are the options and the design of contextual tabs. If you want to hide those contextual tabs, you can click any cell outside of the PivotTable, and when you do in Excel takes those tabs off the Ribbon. If you want to bring them back, just click any cell in the PivotTable and the contextual tabs reappear.

You can also show or hide the PivotTable Field List task pane. So let's say for example that you have raised your PivotTable so that is fairly wide. So let's say that I have Company in the Row Labels area, and then I have Year and then Months in the Column Labels area and that means that my PivotTable is too wide to fit on the screen. If I want to hide the PivotTable Field List to allow more the data t...

Configuring a PivotTable
Video duration: 3m 23s 3h 43m Intermediate

Viewers:

Configuring a PivotTable provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...