![]() |
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... |
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