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

[column headings]

[Stephen]

"column headings" <column headings@discussions.microsoft.com> wrote in
message news:393A9243-0620-480E-A43C-03C3234867EE@microsoft.com...
>

You don't. Excel has plenty of rows - using just one isn't a problem!

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

"Stephen" wrote:

> "column headings" <column headings@discussions.microsoft.com> wrote in
> message news:393A9243-0620-480E-A43C-03C3234867EE@microsoft.com...
> >
>
> You don't. Excel has plenty of rows - using just one isn't a problem!
>
>
>

[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)

"column headings" <columnheadings@discussions.microsoft.com> wrote in
message news:9EBADA39-E51E-4EBE-A81C-B3E9D8EB46E8@microsoft.com...
> 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 headings@discussions.microsoft.com> wrote in
> > message news:393A9243-0620-480E-A43C-03C3234867EE@microsoft.com...
> > >
> >
> > You don't. Excel has plenty of rows - using just one isn't a problem!
> >
> >
> >

[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


--

Regards,

Peo Sjoblom

"column headings" <columnheadings@discussions.microsoft.com> wrote in
message news:9EBADA39-E51E-4EBE-A81C-B3E9D8EB46E8@microsoft.com...
> 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 headings@discussions.microsoft.com> wrote in
> > message news:393A9243-0620-480E-A43C-03C3234867EE@microsoft.com...
> > >
> >
> > You don't. Excel has plenty of rows - using just one isn't a problem!
> >
> >
> >