View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default how do I insert column headings or labels without using a row?

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

=ROW()-1

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

$1:$1


--

Regards,

Peo Sjoblom

"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!