how do I insert column headings or labels without using a row?

C

column headings

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?
 
B

Bob Phillips

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.

File>PAgeSetup>Sheet Rows to repeat as $1:$1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
P

Peo Sjoblom

You have to create your own numbering or use a real database like access or
something (you can hide the default headers under tools>options>view> and
uncheck row & column headers)
you can put this in row 2 and copy down

=ROW()-1

2. Do file>page setup, select sheet and rows to repeat at top and if you are
using row 1 use

$1:$1
 
Top