Column Labels Automatically at the top of each page? LucindaMercer 05.07.2006 16:02:02 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.

RE: Column Labels Automatically at the top of each page? kassie 05.07.2006 19:19:02 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: [Quoted Text] > 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.

Re: Column Labels Automatically at the top of each page? "Nick Hodge" <nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS> 05.07.2006 19:21:44 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[ at ]zen.co.uk.ANDTHIS "LucindaMercer" <LucindaMercer[ at ]discussions.microsoft.com> wrote in message news:4A0B430D-6079-4279-B10E-646EEE832C4E[ at ]microsoft.com... [Quoted Text] >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.

Re: Column Labels Automatically at the top of each page? Gord Dibben <gorddibbATshawDOTca> 05.07.2006 19:38:00 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[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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.