How to print row one on each printed page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print same header at top of each printed page 3
Repeating Rows - Exception 1
Repeat Rows at Top - Except Final Page 2
Help Reg Print 1
Row to repeat while printing 3
Insert automatic page numbering into a cell, not a header or foote 1
Print headings/labels on every page 3
Arggh! Each row prints on separate page 2

Back
Top