Printing 1st row in every page..

C

Carlos

Dear All,

In Microsoft Excel 2000 a user may freeze the first row/pane
(Window menu/Freeze panes) so that it's always viewed
regardless where he is in the spreadsheet.

Is there something similar so that the first row becomes
the printing header row so when printing a 24 pages spreadsheet
every page beggins with that first row?

Thanking you in advance for your help,
Carlos.
 
A

Andy

Carlos said:
Dear All,

In Microsoft Excel 2000 a user may freeze the first row/pane
(Window menu/Freeze panes) so that it's always viewed
regardless where he is in the spreadsheet.

Is there something similar so that the first row becomes
the printing header row so when printing a 24 pages spreadsheet
every page beggins with that first row?
Click to expand...

File > Page Setup > Sheet > Rows to repeat at top and simply select the row
you want.

Andy
 
Top