Repeating Spreadsheet Headings (Rows or Columns) on Each Page

Repeating Spreadsheet Headings (Rows or Columns ) on Each Page

If you have a single heading row or column for a particularly large amount of data, you can set up the heading to repeat on each new printed page. This procedure shows two ways, one where you select what you want to repeat, and one where you type it in.

Selecting the Row or Column Range to Repeat

1. Select the row(s) or column(s) to repeat as shown at right.

   

2. Choose Insert > Names Define. Enter the name of the area in the Name field and click Add.

   You must click Add, not just OK, or it won't work.

3. The name will be added to the list. Select it in the list and click More (see Figure 24-1). Select Repeat row or Repeat column. Click OK.

   Figure 24-1. Specifying that rows or columns should be repeated

   

4. Repeat the previous steps if you have defined repeatable rows and also want to repeat columns, or vice versa.

5. Choose Format > Print Ranges > Edit. In the Rows to repeat list, select the name you assigned to the repeatable area. (see Figure 24-2). Do the same in the Columns to Repeat area if you're repeating columns, as well.

   Figure 24-2. Selecting the name of the area to repeat

   

Entering the Row or Column Range to Repeat

1. Choose Format > Print Ranges > Edit.

2. In the Edit Print Areas window (Figure 24-3), enter the row or column references containing the headers you want to repeat.

   Figure 24-3. Setting up spreadsheet headers to repeat on printed pages

   

3. Click OK.

You can designate more than one row or column as repeatable, shown in Figure 24-3.