There are some possibilities to work with; all of them might not work depending on your spreadsheet.
If the sheet name isn't in the header, choose Format > Page, click the Header tab, click Edit, click in the area where you want the sheet name to show up, then click the Sheet Name icon.
- Choose Format > Print Ranges > Edit.
- Click in the Rows to Repeat (or Columns to Repeat field for columns).
- Just use your mouse to select the rows to repeat.
- Repeat with the other field if you want both columns and rows to repeat.
- Click OK.
You might use IF or other functions to make the contents of the rows you choose to repeat vary for each page. This, of course, would depend a lot on your data and what you want to print on each page.
This was first published in November 2006