User Guide

100
Chapter 6
Hiding Rows and C olumns
Some of the data displayed in a table may not be useful or it may unnecessarily
complicate the table. Fortunately, you can hide entire rows or columns without
losing any d
ata.
E Double-cli
ck the Education Level table.
E Ctrl-Alt-c
lick on the Valid Percent column label to select all of the cells in that column.
E Right-clic
k the highlighted column and select
Hide Category from the pop-up context
menu.
The column is now hidden but not deleted.
To redisplay the column:
E From the menus choose:
View
Show All
Rows can be hidden and displayed in the same way as columns.
Changing Data
Display Formats
You can easily
change the display format of data in pivot tables.
E Double-clic
ktheEducation Level table.
E Click on the P
ercent column label to select it.
E From the menus
choose:
Edit
Select
Data Cells