Thread: HEADER ?
View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Wally" wrote in message
...
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