HEADER ?

W

Wally

I have the first row in my sheet as headers for my colums, when I
print they only show up on the first page.

is there anyway to make them show up on the top of every page?

Thanks

Wally
 
M

Max

Click File > Page Setup > Sheet tab

Under Print Titles, input* in box for:
"Rows to repeat at the top:" : $1:$1 (i.e. for row1)
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
This'll also give return "$1:$1" inside the box
 
Top