Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() In Excel 2002 I would like to have the first two rows show only once at the top of the first page of any printout. I used $1:$2 but it doesn't work as it did in my old Excel 5. Any suggestions would be greatly appreciated. Roger |
#2
![]() |
|||
|
|||
![]()
Roger
To have the top two rows print only on the first page, do not set "Rows to repeat at top". Leave it blank or they will print on every page. Gord Dibben Excel MVP On Sun, 12 Dec 2004 05:44:48 GMT, (Roger Bedford) wrote: In Excel 2002 I would like to have the first two rows show only once at the top of the first page of any printout. I used $1:$2 but it doesn't work as it did in my old Excel 5. Any suggestions would be greatly appreciated. Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel | |||
Variable Print Ranges | Excel Discussion (Misc queries) | |||
"print column titles" | Excel Discussion (Misc queries) | |||
print titles won't appear on some pages | Excel Discussion (Misc queries) |