Thread: printing
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default printing

I misunderstood your original question. Each sheet will print as a separate
job and will not do double sided for multiple worksheets only multiple pages
in one worksheet..
A work around is to make a maste print worksheet which has the appropriate
info from each of the other sheets. this will double side.

"kkm" wrote:


thanks for the suggestion, reinstalling not working; probably doing
something wrong again. two sided printing works fine for single excel sheet
and for whole document of word. when i select two excel sheets on which
print areas have been defined, i expect print area on sheet 2 to print behind
printed area of sheet 1. the two defined areas just print individually. i
hope you can be of help "bj" thanks again.
"bj" wrote:

probably a print driver issue rather than an Excel issue.
Re install the print driver

"kkm" wrote:

cannot print multi-sheet excel document two-sided using HP Laserjet 1320
which has duplex printing capabilities