Repeating rows

D

Desperate!

I am trying to set up the print setup so that the 2 top rows are repeated at
the top of each page printed....help please!
 
M

Max

Click File > Page Setup > Sheet tab

Under Print Titles, input* in box for:
Rows to repeat at the top: $1:$2 (rows1 and 2, for example)

Click OK

*Instead of keying-in, you could also just click inside the box,
then click outside on any cell in row1, say select B1 and drag down to B2

This'll also give return "$1:$2" inside the box
 
Top