Printing Most but not all worksheets

[JeffH]

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?

 

[Gord Dibben]

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

File>Print> 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