print the headings on every page in openoffice spreadsheet

1. Choose Format > Print Ranges > Edit.
2. Click in the Rows to Repeat (or Columns to Repeat field for columns).
3. Just use your mouse to select the rows to repeat.
4. Repeat with the other field if you want both columns and rows to repeat.
5. Click OK.

OpenOffice.org Training, Tips, and Ideas: Spreadsheet Printing Tips: Hiding, Squishing, Printing Headers, and More