Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have a spreadsheet with several pages and one row that repeats at the top of each page when printing. Does anyone know how to exclude a page from having the repeating row from appearing just from that page? Please advise. -- Art Los Angeles, California |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not without setting up two distinct print jobs.
You could do it with VBA but would still be two print jobs. Ron de Bruin has code for printing headers or cell ranges on selected pages. http://www.rondebruin.nl/print.htm#not You could alter to suit. Gord Dibben MS Excel MVP On Mon, 20 Apr 2009 13:23:01 -0700, Art wrote: Hello, I have a spreadsheet with several pages and one row that repeats at the top of each page when printing. Does anyone know how to exclude a page from having the repeating row from appearing just from that page? Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeating rows in Excel | Excel Discussion (Misc queries) | |||
Repeating Rows | Excel Discussion (Misc queries) | |||
Repeating Rows | Excel Worksheet Functions | |||
Repeating rows on new page | Excel Discussion (Misc queries) | |||
delete repeating rows | Excel Worksheet Functions |