ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print setup of a complete workbook (https://www.excelbanter.com/excel-discussion-misc-queries/78853-print-setup-complete-workbook.html)

I Rygert

Print setup of a complete workbook
 
I want to print out all sheets or a selection of sheets in my workbook
without having to setup all the printerinformation sheet by sheet.
I make my printouts by a network printer with different trays, colour or
b/w, staples...
For example, i want to print 10 sheets with the same printsetup. Today i
have to walk through every sheet and make a setup for each one.

Is there anyway i can make a setup for the whole workbook (or selected
sheets) at one time?
Grateful for your answers...


Ardus Petus

Print setup of a complete workbook
 
With Ctrl key press, click on the tabs of the sheets you want to print: this
will group your sheets and enable you to print-setup them at a time.

HTH
--
AP

"I Rygert" <I a écrit dans le message de
...
I want to print out all sheets or a selection of sheets in my workbook
without having to setup all the printerinformation sheet by sheet.
I make my printouts by a network printer with different trays, colour or
b/w, staples...
For example, i want to print 10 sheets with the same printsetup. Today i
have to walk through every sheet and make a setup for each one.

Is there anyway i can make a setup for the whole workbook (or selected
sheets) at one time?
Grateful for your answers...





All times are GMT +1. The time now is 05:40 PM.

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