OpenOffice.org Calc: Print Row and/or Column Headings on Every Page
Posted by Rob Rogers in 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.
About Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers
View more articles by Rob Rogers
The Conversation
Follow the reactions below and share your own thoughts.
June 18, 2010 at 2:53 am, ruCh said:
Thank you
September 08, 2010 at 1:02 pm, Anjan Sarmah said:
Thank you for your valuable comment.
September 27, 2010 at 8:03 pm, Johnston said:
Cool, thanks!
December 13, 2010 at 9:38 am, Gamesbook said:
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?
July 17, 2011 at 10:32 pm, DONOTWANTTOGIVE said:
THANKS!