User Guide

273
Pivot Tables
E
Click Go To.
To Rename a P
ivot Table Bookmark
E Activate t
he pivot table.
E From the me
nus choose:
Pivot
Bookmarks
E
Click the name of the bookmark in the list.
E Click Rename.
E Enter the new bookmark name.
E Click OK.
Showing and
Hiding Cells
Many types o
f cells can be hidden:
 Dimension
labels
 Categorie
s, including the label cell and data cells in a row or column
 Category l
abels (without hiding the data cells)
 Footnotes
, titles, and captions
To Hide Rows and Columns in a Table
E Ctrl-Alt-click the category label of the row or column to be hidden.
E From the Pivot Table menus choose:
View
Hide
or
E Right-click the highlighted row or column to show the context menu.