View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Queenie Chong Queenie Chong is offline
external usenet poster
 
Posts: 2
Default Can you print multiple worksheets double sided?

I'm also finding any long-term solution for this problem.
You may use this method to print as one file on the printing dialogue:

1. Select "Page(s) From __ to __"
2. Select "Active sheet(s)"
3. Press "OK"

"Publisher Lyn" wrote:

We publish an annual publication of detailed tables. Each section of the book
is created in a single Excel workbook - each page of the book is one Excel
sheet. We have tried selecting all sheets and formatting the printer to print
double sided, but each sheet still prints on a separate page. Also, when
trying to number the pages, you can select all sheets, select the first
number, but the same number shows up on all sheets. Is this a limitation of
Excel?