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.
Related Q&A from Solveig Haugland
Our expert tells you how to use search to find strings in OpenOffice.org's Calc.continue reading
An office suite expert describes how to use ODBC with OpenOffice 2.0.continue reading
An office suite expert describes where to find information on OpenOffice 2.0's use in the enterprise worldwide.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.