Microsoft Office Tutorials and References
In Depth Information
Modifying a PivotTable
Use any of the following options to change the PivotTable:
Drill Down, Drill Up, or Drill Cross. Use to view levels of detail in com-
plex data ( New ! ).
Group Selection, Ungroup , or Group Field. Use to group, ungroup PivotT-
able elements or fields.
Clear. Use to clear filters, labels, values, and formatting.
Select. Use to select PivotTable elements.
Fields, Items, & Sets. Use to insert calculated fields and items, change
solve order, and list formulas.
Field List. Show or hide the Field List.
Buttons. Show or hide group +/- buttons.
Field Headers. Show or hide field headers for columns and rows.
Search JabSto ::




Custom Search