Printing several worksheets at once

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

Guest

I have several worksheets in a workbook all configured to print double-sided.
If I want to print say 4 worksheets single-sided, only the worksheet which is
open prints single-sided and the rest print double-sided. I'm using Sharp
printer and according to Sharp, the problem is with Excel. Any ideas or
workaround?
 
try this, not sure if it will work.
go to print menu and select entire workbook. then go to options and select
either single sided or double sided.
 
Joel,

Do four print commands. One sheet at a time. If you do it frequently, record a macro.
 

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

Duplex Printing of Workbook with multiple worksheets 2
Printing Double-Sided 2
Printing Excel Worksheets 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Print worksheet 2 on back of worksheet 1, etc.... 1
Row heights 4
Print on both sides of paper from two worksheets 3
How do I 2 worksheet duplex printing with MS Excel 2003? 1

Back
Top