User Guide
To learn how to Go to
Delete rows and columns “Deleting Table Rows and Columns” on page 58
Use header rows and header columns “Adding Table Header Rows or Header
Columns” on page 59
Freeze header rows and columns so they remain
in view as you scroll through a table’s body rows
and body columns
“Freezing Table Header Rows and Header
Columns” on page 60
Use footer rows “Adding Table Footer Rows” on page 61
Resize rows and columns “Resizing Table Rows and Columns” on page 62
Give every other row in a table a dierent
background color
“Alternating Table Row Colors” on page 62
Hide selected rows and columns “Hiding Table Rows and Columns” on page 63
Sort rows in ascending or descending order using
the value of cells in one or more columns
“Sorting Rows in a Table” on page 64
Hide rows that don’t contain particular values “Filtering Rows in a Table” on page 65
Arrange rows into categories and subcategories
to highlight characteristics they share
“Creating Table Categories” on page 66
“Dening Table Categories and Subcategories” on
page 67
“Removing Table Categories and
Subcategories” on page 72
“Managing Table Categories and
Subcategories” on page 72
Adding Rows to a Table
You can add rows within a table or at the end of a table.
If the table contains a footer row, rows added at the bottom of the table are added
above the footer row. If the table has ltering criteria associated with it, you can’t add
new rows until you stop ltering rows; see “Filtering Rows in a Table” on page 65 for
instructions.
If all the body cells in a column above the new row contain the same formula or cell
control, the formula or cell control is repeated in the new row.
Here are ways to add rows:
To add a row above a selected cell, press Option-Up Arrow. m
To add a row below a selected cell, press Option-Down Arrow.
You can add a single row above or below a particular row by holding the pointer over m
a row’s reference tab to see its menu arrow, clicking the arrow, and then choosing Add
Row Above or Add Row Below from the pop-up menu.
56 Chapter 3 Using Tables