ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel 2003 - 3 or 4 header rows (https://www.excelbanter.com/excel-discussion-misc-queries/83154-excel-2003-3-4-header-rows.html)

Webnut

excel 2003 - 3 or 4 header rows
 
I have a sheet that I would like to have 3 or 4 header rows that would appear
on each page when printing.

Possible?

TIA
Glenna

Niek Otten

excel 2003 - 3 or 4 header rows
 
FilePage setupSheet tab, select Rows to repeat at top

--
Kind regards,

Niek Otten

"Webnut" wrote in message ...
|I have a sheet that I would like to have 3 or 4 header rows that would appear
| on each page when printing.
|
| Possible?
|
| TIA
| Glenna



bpeltzer

excel 2003 - 3 or 4 header rows
 
Use File Page Setup. On the 'Sheet' tab, click in 'Rows to Repeat at Top'
and then select the rows you want repeated (either by clicking or just type
$1:$3, for example).

"Webnut" wrote:

I have a sheet that I would like to have 3 or 4 header rows that would appear
on each page when printing.

Possible?

TIA
Glenna


Gord Dibben

excel 2003 - 3 or 4 header rows
 
Glenna

FilePage SetupSheet. "Rows to repeat at top"

Enter 1:4 or point to those 3 or 4 rows and OK


Gord Dibben MS Excel MVP

On Thu, 13 Apr 2006 13:09:02 -0700, Webnut
wrote:

I have a sheet that I would like to have 3 or 4 header rows that would appear
on each page when printing.

Possible?

TIA
Glenna




All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com