Numbers - Adding Table Header Rows or Header Columns

background image

Adding Table Header Rows or Header Columns

Use header rows and columns when you want to label rows and columns. Header
rows and columns are formatted so that they stand out from the other (body) rows
and columns. Header rows are always directly above the topmost body row. Header
columns are always directly to the left of the leftmost body column.

You can use as many as five header rows and five header columns. Multiple headers
are useful when you want to assign names to two or more header columns or header
rows. To format a header to span rows or columns, merge the header cells, as “Merging
Table Cells” on page 86 describes.

If a table contains both header rows and header columns, the top left cell or cells
are considered to be part of the header row. Header columns appear below any
header rows.

62

Chapter 3

Using Tables

background image

Chapter 3

Using Tables

63

Header rows and header columns can be set to appear at the beginning of the table
and on each page if the table spans more than one page. In Print View, click the
appropriate header button in the format bar and choose “Repeat Header Rows on
Each Page.” If a table spans multiple pages, editing the text or changing the look of a
header row or column in one place changes it consistently throughout the table.

To learn about Print View, see “

Â

Dividing a Sheet into Pages” on page 42.

To learn about keeping headers in view when not working in Print View, see

Â

“Freezing Table Header Rows and Header Columns” on page 64.

Here are ways to add or delete header rows or header columns:
If a table has no headers, select the table and click a Header button in the format bar

m

to add one.
Click it again to remove the header.
Click the disclosure triangle next to a Header button in the toolbar, and then choose

m

the number of header rows or header columns to add from the pop-up menu. Choose
0 to remove all header rows or header columns.

Add header column.

Add header rows.

To delete a header row or header column, hold the pointer over the reference tab of a

m

header row or header column to see its menu arrow. Click the arrow and then choose
Delete Row or Delete column from the pop-up menu.
Select a table or an element in it. Click Inspector in the toolbar, click the Table

m

inspector button, and then click the appropriate Headers & Footer button. Choose the
number of header rows or header columns from the pop-up menu.
Select a table or an element in it and then choose Table > Header Rows or Table >

m

Header Columns. Then choose the number of header rows or header columns from
the submenu.
Convert the topmost body row or the leftmost body column to a header row or

m

header column. Hold the pointer over the reference tab of a body row or column
to see its menu arrow. Click the arrow and then choose Convert to Header Row or
Convert to Header Column from the pop-up menu. These commands are available
only when there are four or fewer existing header rows or header columns.

Header cells play an important role in making formulas in table cells easier to read and
create. See “Referring to Cells in Formulas” on page 126 to learn more.