| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print header row on all pages except last page
I would like to print a worksheet that is 12 pages and repeat rows on 11
pages except the last one since the the last page is the total page. HELP!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
print header row on all pages except last page
The first part is easy enough. Filepage setup Sheet tab. Enter the rows you
want to repeat on EVERY page. This will reprint yoru specified rows on each page of teh print out. It will, however, also print on the last page. Maybe one of the MVP's has a solution to eliminate them on the last page! HTH "Woofaloo" wrote: I would like to print a worksheet that is 12 pages and repeat rows on 11 pages except the last one since the the last page is the total page. HELP!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
print header row on all pages except last page
Yes thanks. I have the "all pages" covered. Someone told me it's a formula
to place in the Print Titles in the page setup. I am "Formula Ignorant" so I need help....It seems that you should be able to un-include rows or stop a a particular row. Thanks again.... "JR Hester" wrote: The first part is easy enough. Filepage setup Sheet tab. Enter the rows you want to repeat on EVERY page. This will reprint yoru specified rows on each page of teh print out. It will, however, also print on the last page. Maybe one of the MVP's has a solution to eliminate them on the last page! HTH "Woofaloo" wrote: I would like to print a worksheet that is 12 pages and repeat rows on 11 pages except the last one since the the last page is the total page. HELP!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
print header row on all pages except last page
Woof
Sub rows_to_repeat() With ActiveSheet.PageSetup .PrintTitleRows = "$1:$1" ActiveSheet.PrintOut From:=1, To:=11 .PrintTitleRows = "" ActiveSheet.PrintOut From:=12, To:=12 End With End Sub Gord Dibben MS Excel MVP On Wed, 10 Jan 2007 12:07:01 -0800, Woofaloo wrote: I would like to print a worksheet that is 12 pages and repeat rows on 11 pages except the last one since the the last page is the total page. HELP!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel File is shrinking two pages to fit to one page | Excel Discussion (Misc queries) | |||
| print preview v page break preview | Excel Discussion (Misc queries) | |||
| print a certain row as the header on each page | Excel Discussion (Misc queries) | |||
| header/footer "page 1 of 'x' pages" | Excel Discussion (Misc queries) | |||
| How can I print a different header on each page of an Excel Sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
