Printing Most but not all worksheets

G

Guest

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?
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing multiple worksheets in a workbook 1
Page Numbers not working correctly 2
Page Numbers not working 1
Problem printing all worksheets in colour 1
Not printing the entire workbook 2
Printing multiple worksheets in a workbook 3
Set the print order of worksheets when printing entire workbook 2
Duplex Printing of Workbook with multiple worksheets 2

Top