Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #21   Report Post  
Old May 24th 18, 11:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2018
Posts: 1
Default Can you print multiple worksheets double sided?

On Wednesday, December 6, 2006 at 2:31:56 AM UTC-8, wrote:
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?


I think... what you need to do is set the print area on each sheet of
the work book so that you have one page on each sheet, do this for each
sheet. Then... this is the annoying part and the only way I have
managed to make this work. Click on each sheet then click FilePrint.
Go into the properties and click double sided as I'm sure you have
already done... then instead if clicking ok to start printing click
close. Then repeat this process for each individual sheet by tabbing
accross to each one clicking print and then changing the property. Once
you have done this for all sheets go back to the first sheet, click
print then select entire workbook and then press ok. I believe this
should then print each sheet back to back accross the entire workbook.
At least I have got it to do this anyway after much faffing around!


I tried using Microsoft XPS Printer, it wouldn't print duplex. PDF WOULD.

  #22   Report Post  
Old May 26th 18, 12:36 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 229
Default Can you print multiple worksheets double sided?

I have not found a workaround to this, and have come across this limitation often. In my experience, it looks like Excel applies the correct settings to the first sheet, but the default to all the other ones.

The best solution I have ever come up with is to change the default printer settings on your system, then print. Or, another (much more cumbersome way) sometimes in one of my past jobs, we would copy-as-picture (shown as printed) and created a PowerPoint file with each sheet - it was the bane of my existence then, and I do not recommend it unless necessary (for example if you want other PPT elements on each page besides the Excel graphic).

On Thursday, October 12, 2006 at 11:22:01 AM UTC-4, 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Functions across multiple worksheets starlight Excel Worksheet Functions 0 August 10th 05 05:10 PM
Printing Multiple Worksheets Linda Excel Discussion (Misc queries) 1 August 8th 05 05:12 PM
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 3 December 31st 04 10:31 AM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 2nd 04 11:23 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017