Column Labels Automatically at the top of each page?

I would like to have the column labels appear at the top of each page
automatically. I am working with a spreadsheet in which I am either adding
rows, or wrapping text in a cell so that particular row gets wider, which
changes where the page breaks are. As a result, every time I work with the
spreadsheet, I have to manually move the column labels from their current
rows to the row at the top of the next page so that when I print the
spreadsheet, which is shared with others, we know what each column represents
on the several pages of the full spreadsheet.

Is this possible? I am using Excel 2003.

I take it the labels you refer to are in row 1?

In Excel, click on File|PageSetup, select Sheet. and fill in the box "Rows
to repeat at top of each page". You do not have to copy your column headings
down

"LucindaMercer" wrote:

> I would like to have the column labels appear at the top of each page
> automatically. I am working with a spreadsheet in which I am either adding
> rows, or wrapping text in a cell so that particular row gets wider, which
> changes where the page breaks are. As a result, every time I work with the
> spreadsheet, I have to manually move the column labels from their current
> rows to the row at the top of the next page so that when I print the
> spreadsheet, which is shared with others, we know what each column represents
> on the several pages of the full spreadsheet.
>
> Is this possible? I am using Excel 2003.

Lucinda

If you mean on the printout, then File>Page setup...>Sheet tab, 'Rows to
repeat at top and enter 1:1 or similar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"LucindaMercer" <LucindaMercer@discussions.microsoft.com> wrote in message
news:4A0B430D-6079-4279-B10E-646EEE832C4E@microsoft.com...
>I would like to have the column labels appear at the top of each page
> automatically. I am working with a spreadsheet in which I am either
> adding
> rows, or wrapping text in a cell so that particular row gets wider, which
> changes where the page breaks are. As a result, every time I work with
> the
> spreadsheet, I have to manually move the column labels from their current
> rows to the row at the top of the next page so that when I print the
> spreadsheet, which is shared with others, we know what each column
> represents
> on the several pages of the full spreadsheet.
>
> Is this possible? I am using Excel 2003.

For printing........

File>Page Setup>Sheet>Rows to repeat at top.

Enter $1:$1 or just point to row 1 using the range selection box.


Gord Dibben MS Excel MVP


On Wed, 5 Jul 2006 09:02:02 -0700, LucindaMercer
<LucindaMercer@discussions.microsoft.com> wrote:

>I would like to have the column labels appear at the top of each page
>automatically. I am working with a spreadsheet in which I am either adding
>rows, or wrapping text in a cell so that particular row gets wider, which
>changes where the page breaks are. As a result, every time I work with the
>spreadsheet, I have to manually move the column labels from their current
>rows to the row at the top of the next page so that when I print the
>spreadsheet, which is shared with others, we know what each column represents
>on the several pages of the full spreadsheet.
>
>Is this possible? I am using Excel 2003.