ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing a few pages w/ whole workbook pagination (https://www.excelbanter.com/excel-discussion-misc-queries/126610-printing-few-pages-w-whole-workbook-pagination.html)

shanep

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?

Gord Dibben

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?



shanep

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?




Gord Dibben

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?






All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com