How to print row one on each printed page

P

Pleiades

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
 
D

Dave Peterson

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.)
 
Top