I want the first row to be column header for each page when printed, I have it showing up while scrolling but it wont print it out so that the first row shows up on each printed page
Writer or Calc?
Spreadsheet
You tagged your question common, I’ll answer for Writer and Calc. The question doesn’t make sense for the other components Impress, Draw and Math. It may be relevant for Base but this is handled through the report generator.
#Writer
Right-click in your table and Table Properties or menu Table>Properties. Go to the Text Flow tab. Check box Repeat heading and choose the number of rows.
#Calc
To keep rows or columns always on screen even when scrolling: select the top rows (or left columns) to keep in view and View>Freeze Rows & Columns or more simply without selection View>``Freeze Cells>Freeze First Column/Row`.
To set the heading rows and columns for print, Format>Print Range>Edit
Nota bene: this information is readily available in the built-in help!
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
In case you need clarification, edit your question (not an answer which is reserved for solutions) or comment the relevant answer.
1 Like
That only freezes it for viewing each sheet, I want that to print on the first row of every sheet.
You can do this way:
1. Open the Calc file and go to the sheet which you want to print.
2. From menu select: Format -> Print Ranges -> Edit
3. To repeat rows in every print page, select “user defined” and click on the small button to choose the row to repeat. If you select the first row of a sheet, it should have $1 (see below), for the second it would be $2 and so on.
Detailed guide available here.