default printer setup for individual worksheet only

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

Is it possible to set different default printer settings
for individual workbooks? ie- I have one workbook that
contains twelve worksheets...I want these to print by
default on 8 1/2 x 14 legal paper. All other workbooks, I
want to print standard 8 1/2 x 11. I would like to be able
to do this without having to open file/page setup/etc.
each time.
Thanks,
Al
 
Al

The page setup is saved with the workbook.

For that particulae workbook you should be able to setup as you wish and save
it.

Other workbooks would take the default settings which are set with the Printer
Settings through Start>Settings>Printer and Faxes>Properties(of your printer).

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

set a permanent paper size 2
Print worksheet 2 on back of worksheet 1, etc.... 1
Printing Worksheet/Workbook 2
How to change the printer paper source for all worksheets in a wrk 14
default number of copies 1
Number of Copies for worksheet defaults to 5 incorrectly 1
Change default printing options to print only worksheet 4
Set default cell format while retaining overrides 3

Back
Top