\<bookmark_value\>printing; sheets on multiple pages\</bookmark_value\>\<bookmark_value\>sheets; printing on multiple pages\</bookmark_value\>\<bookmark_value\>rows; repeating when printing\</bookmark_value\>\<bookmark_value\>columns; repeating when printing\</bookmark_value\>\<bookmark_value\>repeating;columns/rows on printed pages\</bookmark_value\>\<bookmark_value\>title rows; printing on all sheets\</bookmark_value\>\<bookmark_value\>headers; printing on sheets\</bookmark_value\>\<bookmark_value\>footers; printing on sheets\</bookmark_value\>\<bookmark_value\>printing; rows/columns as table headings\</bookmark_value\>\<bookmark_value\>headings;repeating rows/columns as\</bookmark_value\>

Printing Rows or Columns on Every Page

If you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page.

As an example, If you want to print the top two rows of the sheet as well as the first column (A) on all pages, do the following:

  1. Choose \<emph\>Format - Print Ranges - Edit\</emph\>. The \<emph\>Edit Print Ranges\</emph\> dialog appears.

  2. Click the icon at the far right of the \<emph\>Rows to repeat\</emph\> area.

    The dialog shrinks so that you can see more of the sheet.

  3. Select the first two rows and, for this example, click cell A1 and drag to A2.

    In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows to repeat.

  4. Click the icon at the far right of the \<emph\>Rows to repeat\</emph\> area. The dialog is restored again.

  5. If you also want column A as a column to repeat, click the icon at the far right of the \<emph\>Columns to repeat\</emph\> area.

  6. Click column A (not in the column header).

  7. Click the icon again at the far right of the \<emph\>Columns to repeat\</emph\> area.

Note Icon

Rows to repeat are rows from the sheet. You can define headers and footers to be printed on each print page independently of this in \<emph\>Format - Page\</emph\>.