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