How can I print only select sheets in my workbook?

  • Thread starter Thread starter MVictoreen
  • Start date Start date
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
 
Select sheet2 then hold SHIFT key and click on sheet9

File>Print>Active Sheet(s)


Gord Dibben MS Excel MVP
 
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.
 
Back
Top