Page 710 - Excel 2013 All-in-One For Dummies

692 Modifying the Pivot Table
Figure 2-14:
Modifying the pivot table options
in the PivotTable Options dialog box.
The PivotTable Options dialog box contains the following six tabs:
✦ Layout & Format with options for controlling the various aspects of the layout and formatting of the cells in the pivot table
✦ Totals & Filters with options for controlling the display of the subtotals and grand totals in the report, and filtering and sorting the table’s fields
✦ Display with options for controlling the display items in the table and the sorting of the fields in the PivotTable
✦ Printing with options for controlling print expand and collapse but- tons when displayed in the pivot table, and print titles with the row and column labels on each page of the printout
✦ Data with options for controlling how the data that supports the pivot table is stored and refreshed
✦ Alt Text with options for adding alternate, text-based titles and descrip- tions of the information in the pivot table for those with vision impair- ments who then hear the title and description read aloud
Perhaps the most important pivot table option is the Classic PivotTable Layout (Enables Dragging of Fields in the Grid) check box option on the Display tab. When you select this check box, Excel lets you rearrange the fields within the pivot table simply by dragging their icons onto the desired part of the table (Table Filter, Column Labels, or Row Labels). The program also lets you add fields to the pivot table by dragging them from the field list in the PivotTable Fields task pane and dropping them on the part of the table to which they are to be added.