| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i print (row) titles on all pages except the last page?
i would like to print a worksheet with rows and rows of data. I set a row
heading on all pages in the page setup area. However, the last page (which will appear as a signature page) is not data and i do not want the row heading to print on that page. Is this possible? thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i print (row) titles on all pages except the last page?
No, but gee, that would be a nice idea.
"di" wrote: i would like to print a worksheet with rows and rows of data. I set a row heading on all pages in the page setup area. However, the last page (which will appear as a signature page) is not data and i do not want the row heading to print on that page. Is this possible? thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i print (row) titles on all pages except the last page?
Do two separate print jobs.
Makes it easier if you use VBA code See Ron de Bruin's site for that. http://www.rondebruin.nl/print.htm#not Gord Dibben MS Excel MVP On Fri, 7 Nov 2008 12:32:14 -0800, di wrote: i would like to print a worksheet with rows and rows of data. I set a row heading on all pages in the page setup area. However, the last page (which will appear as a signature page) is not data and i do not want the row heading to print on that page. Is this possible? thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i print (row) titles on all pages except the last page?
See Gord's reply, or place the "signature page" on a different worksheet.
di wrote: i would like to print a worksheet with rows and rows of data. I set a row heading on all pages in the page setup area. However, the last page (which will appear as a signature page) is not data and i do not want the row heading to print on that page. Is this possible? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change print titles (rows to repeat at top) on subsequent pages | Excel Discussion (Misc queries) | |||
| Print titles on some pages and not others? | Setting up and Configuration of Excel | |||
| print different row titles in one sheet w/ many pages | Excel Worksheet Functions | |||
| How do you set titles to print on multiple pages? | Excel Discussion (Misc queries) | |||
| print titles won't appear on some pages | Excel Discussion (Misc queries) | |||
Hybrid Mode
