This section describes the capabilities provided by the Pivot Table, which represents data in a cross-tabulated form.

 

Data Presentation

•Sort Data in Pivot Tables

Describes how you can sort field values alphabetically or by summary values displayed in a particular column or row.

•Filter Data in Pivot Tables

Provides information on how to filter data by hiding specific rows or columns via filter drop-down lists, and how to provide more advanced filtering by building a complex filter condition.

•Apply Conditional Formatting

Describes how to change the appearance of individual cells based on specific conditions.

•Change Summary Type in Pivot Tables

Describes how to specify which calculations the Pivot Table should perform against its data.

•Pinned (Fixed) Columns

Describes how to pin columns in the Pivot Table.

 

Layout Customization

•Expand and Collapse Groups in Pivot Tables

Provides information on how to expand and collapse field values and field headers.

•Hide Pivot Table Fields

Guides you through the process of hiding Pivot Table fields.

•Display Hidden Pivot Table Fields

Describes how to display fields that have previously been hidden.

•Reorder Pivot Table Fields

Provides information on how to reorder Pivot Table fields.

 

Selection and Navigation

•Select Cells in Pivot Tables

Describes how to select a single or multiple cells, and copy their contents to the clipboard.

 

Field List

•Field List Overview

Provides basic information about Field Lists.

•Invoke a Field List

Describes how to invoke a Field List.

•Defer Pivot Table Updates

Describes how to prevent automatic Pivot Table updates and force it to update manually.

•Change Field List Layout