Print setup of a complete workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

page setup 2
Workbook Printing Problem 1
Combining Print Jobs Together 1
Printing Sheets in a Workbook 3
page setup 3
Cannot print in colour in Excel 2003 1
How do I set a print area for every sheet in the workbook? 2
Link one worksheet in a workbook to another worksheet in same work 1

Back
Top