You could hide row and column headings and then in A2 add a formula of
=ROW(A1) and copy down. Colour the cells grey and voila.
FilePAgeSetupSheet Rows to repeat as $1:$1
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"column headings" wrote in
message ...
Thanks.. But then the row numbering is "taken up" by the title and the
"first" row of data is numbered 2. Is there a way to avoid this? Also, how
do
I designate this first row as a "Column Heading" so that it reprints on
every
page?
"Stephen" wrote:
"column headings" <column wrote in
message ...
You don't. Excel has plenty of rows - using just one isn't a problem!