How to print row one on each printed page
 

from Page set up/sheet/rows to repeat at top.....I've tried entering 1 on
the line to repeat rows but I get a message, "Reference not valid", I've
missed something important but...what?
Thank you

How to print row one on each printed page
 

It's looking for a range address.

Type 1:1
or click in that box (delete the existing entry) and then click on row 1.

(That'll let excel do the heavy lifting.)

Pleiades wrote:

from Page set up/sheet/rows to repeat at top.....I've tried entering 1 on
the line to repeat rows but I get a message, "Reference not valid", I've
missed something important but...what?
Thank you

--

Dave Peterson