Use rows 1-3 for header on all 13 pages
 

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

Use rows 1-3 for header on all 13 pages
 

FilePage SetupSheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten

"sjl" wrote in message ...
| 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

Use rows 1-3 for header on all 13 pages
 

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

"Niek Otten" wrote:

FilePage SetupSheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten

"sjl" wrote in message ...
| 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

Use rows 1-3 for header on all 13 pages
 

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

"STEC" wrote in message
...
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???

"Niek Otten" wrote:

FilePage SetupSheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten

"sjl" wrote in message
...
| 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