Excel® 2013 On Demand

Working with PivotTable Data

After you create a PivotTable, you can use several features to enhance the display of the information you want. You can fill down and repeat labels to make viewing data easier, use the Search box to find data in fields and columns, use the AutoFilter menu to filter data in fields and columns, and use options to display data in different ways. When you sort and filter large amounts of data in a PivotTable, Excel uses multi-threading to improve performance. Excel also provides support for the Undo command in large PivotTables.

Work with Values in a PivotTable

Click the data field in the PivotTable you want to change. ...