OpenOffice.org Calc: Print Row and/or Column Headings on Every Page
Contributed by Rob Rogers 
Tagged: Windows In large spreadsheets, it is quite useful to include the columns and/or row headings on each page so that the user of the document can easily find the data they are looking for without having to refer to the first page to locate the proper headings.
1. Click Format.
2. Mouseover Print Ranges and select Edit.
3. To print row headings on each page, click in the Rows to repeat textbox then select the cells in the spreadsheet. To print column headings click in the Columns to repeat textbox then select the cells in the spreadsheet.
4. Click OK.
You may also like -
Creating Databases the Quick, Easy Way With OpenOffice.org
Making Labels with Openoffice.org Templates
OpenOffice.org Calc: Show Formulas to Verify Your Equations
Google Spreadsheets: How To Add or Remove Rows and Columns
OpenOffice.org Calc: Stop Printing Empty Pages
Word 2007: Use Columns in Your Document
OpenOffice.org Writer: Use Columns in Your Document
OpenOffice.org: Change the AutoRecovery Save Interval
ruCh said on June 18, 2010
Thank you :)
Anjan Sarmah said on September 8, 2010
Thank you for your valuable comment.
Johnston said on September 27, 2010
Cool, thanks!
Gamesbook said on December 13, 2010
I get an “invalid sheet reference” when I try this – the end result of “select the cells in the spreadsheet” is an entry such as $A:$H. What could be wrong?
DONOTWANTTOGIVE said on July 17, 2011
THANKS!