I've been using Print Entire Workbook to print the many reports I have in an
Excel workbook. I use this option and it keeps the page numbers in
sequential order which is great, but now I have added a couple of worksheets
that I do not want to print. I print the reports to Adobe.

Is there a way in which I can print some but not all worksheets and still
keep the page numbers in the correct order?

Select the sheets to print by CTRL + click on the sheet tabs.

FilePrint Print Active Sheet(s)

The page numbers will be sequential for just those selected sheets.

Note: you can use this method to set most print settings globally for those
sheets selected.


Gord Dibben MS Excel MVP


On Wed, 1 Aug 2007 07:36:02 -0700, JeffH
wrote:

I've been using Print Entire Workbook to print the many reports I have in an
Excel workbook. I use this option and it keeps the page numbers in
sequential order which is great, but now I have added a couple of worksheets
that I do not want to print. I print the reports to Adobe.

Is there a way in which I can print some but not all worksheets and still
keep the page numbers in the correct order?