Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2006

Tip: Looking for answers? Try searching our database.

I want to duplex a workbook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MsDaisey - 16 Oct 2006 18:51 GMT
I have an annual report that includes a workbook of 16 pages that I want to
duplex.  When I go to print using the duplex feature it still prints single
pages.
Pete_UK - 16 Oct 2006 20:35 GMT
This will be down to your printer driver, rather than Excel. However,
click on File | Page Setup and you will see three buttons on the right
of the panel - click Options to get to the printer facilities, and you
ought to see Duplex settings here.

Hope this helps.

Pete

> I have an annual report that includes a workbook of 16 pages that I want to
> duplex.  When I go to print using the duplex feature it still prints single
> pages.
Patrick - 16 Oct 2006 23:22 GMT
I believe this is a function of Excel, not the print driver.
Can someone confirm?

> I have an annual report that includes a workbook of 16 pages that I want to
> duplex.  When I go to print using the duplex feature it still prints single
> pages.
Gord Dibben - 17 Oct 2006 00:02 GMT
It is a function of the Printer Driver to print duplex.

Maybe MsDaisey has incorrect printer as default?

If your printer does not support duplexing you will not get the option in Excel.

My printer does not support duplexing so I use a macro to print one side, turn
the sheets in the print tray then print the other side.

Gord Dibben  MS Excel MVP

>I believe this is a function of Excel, not the print driver.
>Can someone confirm?
>
>> I have an annual report that includes a workbook of 16 pages that I want to
>> duplex.  When I go to print using the duplex feature it still prints single
>> pages.
Pete_UK - 17 Oct 2006 00:11 GMT
Gord,

how does the macro turn the sheets in the print tray? <vg>

Pete

> It is a function of the Printer Driver to print duplex.
>
[quoted text clipped - 13 lines]
> >> duplex.  When I go to print using the duplex feature it still prints single
> >> pages.
Gord Dibben - 17 Oct 2006 00:44 GMT
Touché<g>

Gord

>Gord,
>
[quoted text clipped - 19 lines]
>> >> duplex.  When I go to print using the duplex feature it still prints single
>> >> pages.

Gord Dibben  MS Excel MVP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.