Repeating rows and columns on each page

You can repeat a row or a row range (a column or a column range) on each page when printing a spreadsheet document. To do so, select a row or a row range (a column or a column range) and then, on the main menu, point to Table, point to Print Options, and click Running Area.

The selected range is placed on the first page in the same way it is placed in the spreadsheet, that is, in accordance with its position on the sheet related to the column and row headers. On the subsequent pages, repeated rows are located at the top of each page, while columns are located at the left of each page.

To cancel repeating all rows and columns, on the main menu, point to Table, point to Print Options, and click Remove Repetition.

Repeated rows and columns are not carried over from spreadsheets to final documents. You can also view and change repeated rows and columns in the spreadsheet property palette.

Next page: Specifying print area

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.