| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing non-contiguous rows at the top
Using the 'rows to repeat at top' field of page setup, is there a way to
print non-connected rows (i.e. rows 1, 2, 5, & 6)? The formula only allows for $1:$x and all rows inclusive. -- Rich Burt Fresno, CA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Printing non-contiguous rows at the top
Try using Rows(1:6) and then hide Rows(3:4)
If that messes up the appearance of page one then print page 1 separately. -- Jim Cone Portland, Oregon USA "Rich Burt" .(donotspam) wrote in message Using the 'rows to repeat at top' field of page setup, is there a way to print non-connected rows (i.e. rows 1, 2, 5, & 6)? The formula only allows for $1:$x and all rows inclusive. -- Rich Burt Fresno, CA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to automatically delete non-contiguous rows | Excel Discussion (Misc queries) | |||
| AVERAGEing non contiguous rows | Excel Discussion (Misc queries) | |||
| Macro to repeat 2 contiguous rows to top of each page | Excel Discussion (Misc queries) | |||
| Selecting a group of contiguous rows | Excel Discussion (Misc queries) | |||
| total column amounts from non-contiguous rows | Excel Discussion (Misc queries) | |||
Linear Mode
