In Page Setup Sheet tab,

Put in box for "Rows to repeat at top:" $1:$1

(Or, just click inside the box,
then click outside and select any cell in row1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RAT53" wrote in message
...
I want to repeat the column headings I have set in Row 1 on each page when
printing out. It appears you can do this by saying what row you want to
repeat in the Sheet window; however it doesn't say in what format this
needs
to be expressed. I tried to just enter a 1 (for Row 1) and it tells me it
is
the wrong format. Any advice welcome