OpenOffice.org Calc: Print Row and/or Column Headings on Every Page

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

The Conversation

Follow the reactions below and share your own thoughts.

5 Responses to “OpenOffice.org Calc: Print Row and/or Column Headings on Every Page”

  1. June 18, 2010 at 2:53 am, ruCh said:

    Thank you :)

    Reply

  2. September 08, 2010 at 1:02 pm, Anjan Sarmah said:

    Thank you for your valuable comment.

    Reply

  3. September 27, 2010 at 8:03 pm, Johnston said:

    Cool, thanks!

    Reply

  4. 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?

    Reply

  5. July 17, 2011 at 10:32 pm, DONOTWANTTOGIVE said:

    THANKS!

    Reply

Leave a Reply