Hiding Table Rows and Columns
Hide specific rows or columns when you want to avoid showing or using them but
don’t want to delete them. While a row or column is hidden, it can’t be reformatted,
merged, split, or otherwise manipulated. However, any formula that uses a hidden cell
isn’t affected, and sorting takes hidden values into account.
When a row or column is hidden, you’ll see a gap in the row numbers or column
letters in the reference tabs.
Here are ways to hide and show rows and columns:
To hide a single row or column, choose Hide Row or Hide Column from the row or
m
column reference tab’s pop-up menu.
66
Chapter 3
Using Tables
Chapter 3
Using Tables
67
To hide multiple rows or columns, select the rows or a cell in each of them and
then choose Hide Selected Rows or Hide Selected Columns from a reference tab pop-
up menu.
To show all hidden rows and columns in a table, select the table or an element in it
m
and then choose Table > Unhide All Rows or Table > Unhide All Columns.
You can also choose these commands from any reference tab’s pop-up menu.
To show rows hidden immediately above a row or columns hidden immediately to
m
the left of a column, click the reference tab for the row or column and then
choose “Unhide Rows row numbers“ or “Unhide Columns column letters” from the pop-
up menu.
To show rows or columns hidden in a selected range of rows or columns, select the
m
range and then choose Unhide Selected Rows from the pop-up menu of any of the
selected rows or columns.
Rows or columns that are hidden in Numbers tables are removed when the tables are
copied into other iWork applications.
Rows and columns that contain merged cells can’t be hidden.