| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| How do I set my workbook up to print only first 2 pages? | Excel Discussion (Misc queries) | |||
| How do I remove unwanted banner pages in excel workbook print | Excel Discussion (Misc queries) | |||
| In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) | |||
| Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) | |||
Linear Mode
