How can I print only select sheets in my workbook?
 

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

How can I print only select sheets in my workbook?
 

Select sheet2 then hold SHIFT key and click on sheet9

FilePrintActive Sheet(s)


Gord Dibben MS Excel MVP

On Thu, 27 Mar 2008 19:14:00 -0700, MVictoreen
wrote:

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

How can I print only select sheets in my workbook?
 

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 FILEPRINTACTIVE SHEET(S). CTRL allows you to select multiple sheets
in ant order.