| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing a few pages w/ whole workbook pagination
I often print large workbooks and inevitably find errors on a few pages. Is
there anyway to print these pages with the workbook page sequence preserved? example workbook = page 1 of 84. I print replacement pages and they number "page 1 of 3". I want page 64 0f 84 to retain the 64 of 84 page number. Can I do this without printing the entire workbook again and wasting paper in the process? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing a few pages w/ whole workbook pagination
FilePrintPage
Print Range Page(s) from: 64 to: 64 should give you page 64 of 84. Or 12 to 13 will print 12 of 84, 13 of 84 Do a print preview to check but on my Excel 2003 this functioned properly. Gord Dibben MS Excel MVP On Thu, 18 Jan 2007 08:18:02 -0800, shanep wrote: I often print large workbooks and inevitably find errors on a few pages. Is there anyway to print these pages with the workbook page sequence preserved? example workbook = page 1 of 84. I print replacement pages and they number "page 1 of 3". I want page 64 0f 84 to retain the 64 of 84 page number. Can I do this without printing the entire workbook again and wasting paper in the process? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing a few pages w/ whole workbook pagination
Thanks so much. I was grouping individual sheets and then printing. Easy
enough solution. A Little Embarassed "Gord Dibben" wrote: FilePrintPage Print Range Page(s) from: 64 to: 64 should give you page 64 of 84. Or 12 to 13 will print 12 of 84, 13 of 84 Do a print preview to check but on my Excel 2003 this functioned properly. Gord Dibben MS Excel MVP On Thu, 18 Jan 2007 08:18:02 -0800, shanep wrote: I often print large workbooks and inevitably find errors on a few pages. Is there anyway to print these pages with the workbook page sequence preserved? example workbook = page 1 of 84. I print replacement pages and they number "page 1 of 3". I want page 64 0f 84 to retain the 64 of 84 page number. Can I do this without printing the entire workbook again and wasting paper in the process? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing a few pages w/ whole workbook pagination
Thanks for the feedback.
Gord On Thu, 18 Jan 2007 13:50:03 -0800, shanep wrote: Thanks so much. I was grouping individual sheets and then printing. Easy enough solution. A Little Embarassed "Gord Dibben" wrote: FilePrintPage Print Range Page(s) from: 64 to: 64 should give you page 64 of 84. Or 12 to 13 will print 12 of 84, 13 of 84 Do a print preview to check but on my Excel 2003 this functioned properly. Gord Dibben MS Excel MVP On Thu, 18 Jan 2007 08:18:02 -0800, shanep wrote: I often print large workbooks and inevitably find errors on a few pages. Is there anyway to print these pages with the workbook page sequence preserved? example workbook = page 1 of 84. I print replacement pages and they number "page 1 of 3". I want page 64 0f 84 to retain the 64 of 84 page number. Can I do this without printing the entire workbook again and wasting paper in the process? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One workbook to another . . . | Excel Discussion (Misc queries) | |||
| Should all pages in a workbook print in color? | Excel Discussion (Misc queries) | |||
| Varying page Excel report | Excel Discussion (Misc queries) | |||
| How do you only save 4 pages of the workbook | Excel Worksheet Functions | |||
Linear Mode
