Use rows 1-3 for header on all 13 pages

S

sjl

My spreadsheet has 15 columns of numbers and is quite long. I want the first
3 rows (my header) to print at the top of each page. Is there a way to do
this.

Thanks,
SJL
 
N

Niek Otten

File>Page Setup>Sheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten

| My spreadsheet has 15 columns of numbers and is quite long. I want the first
| 3 rows (my header) to print at the top of each page. Is there a way to do
| this.
|
| Thanks,
| SJL
 
S

STEC

I have done this but I'm not quite sure what to add in the space. What ever I
put it states "reference invalid" ... what am I doing wrong???
 
D

David Biddulph

The easiest way is to click in the space, then to select whichever row(s)
you wish to be repeated on each page.
 
Top