How can I print only select sheets in my workbook?

M

MVictoreen

My workbook has 12 sheets, but I want to print the second through ninth sheet
exclusively, each time I hit print. (I do this once a week.) How do I do it?
Excel 2007
 
G

Gord Dibben

Select sheet2 then hold SHIFT key and click on sheet9

File>Print>Active Sheet(s)


Gord Dibben MS Excel MVP
 
L

Lt. Bonifacius

Hi MVictoreen!
As an optional method to Gord Dibben's post, you can select the sheets you
want to print by holding CTRL and clicking the sheets you want to print, the
go to FILE>PRINT>ACTIVE SHEET(S). CTRL allows you to select multiple sheets
in ant order.
 

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

Need help formatting a sheet 0
Excel print area which only prints pages of worksheet which are active 0
Excel, assign cells in multiple worksheets from one sheet 1
Copy sheet 3
How do I print sheets in Excel without blank sheets after page 2
Macro to copy value in field and insert it into filter 2
Print entire workbook with each sheet starting at page 1 8
Printing Sheets in a Workbook 3

Top