ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Multiple Sheets (https://www.excelbanter.com/excel-discussion-misc-queries/162510-printing-multiple-sheets.html)

chad

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

Thank you

Gord Dibben

Printing Multiple Sheets
 
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



JR Hester

Printing Multiple Sheets
 
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


chad

Printing Multiple Sheets
 
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





All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com