Does anyone know how to print multiple sheets of a workbook with one print job?

Thank you

Select first sheet tab then CTRL + click on each non-contiguous sheet you want
to print.

Or SHIFT + click for contiguous sheets.

Or if you want to print all sheets just Right-click on a sheet tab and "Select
all sheets"

Or FilePrint. Checkmark in "Entire workbook"


Gord Dibben MS Excel MVP


On Wed, 17 Oct 2007 13:05:00 -0700, Chad wrote:

Does anyone know how to print multiple sheets of a workbook with one print job?

Thank you

File Print: Select entire workbook at bottom left, then number of copies at
bottom right. Was this what you were looking for?

"Chad" wrote:

Does anyone know how to print multiple sheets of a workbook with one print job?

Thank you

Thank you - I knew it wold be simple but not that simple! Thank you again.

"Gord Dibben" wrote:

Select first sheet tab then CTRL + click on each non-contiguous sheet you want
to print.

Or SHIFT + click for contiguous sheets.

Or if you want to print all sheets just Right-click on a sheet tab and "Select
all sheets"

Or FilePrint. Checkmark in "Entire workbook"


Gord Dibben MS Excel MVP


On Wed, 17 Oct 2007 13:05:00 -0700, Chad wrote:

Does anyone know how to print multiple sheets of a workbook with one print job?

Thank you