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.

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

MsDaisey wrote:
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.

I believe this is a function of Excel, not the print driver.
Can someone confirm?

"MsDaisey" wrote:

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.

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

On Mon, 16 Oct 2006 15:22:01 -0700, Patrick
wrote:

I believe this is a function of Excel, not the print driver.
Can someone confirm?

"MsDaisey" wrote:

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,

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

Pete

Gord Dibben wrote:
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

On Mon, 16 Oct 2006 15:22:01 -0700, Patrick
wrote:

I believe this is a function of Excel, not the print driver.
Can someone confirm?

"MsDaisey" wrote:

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.

Touché<g

Gord

On 16 Oct 2006 16:11:16 -0700, "Pete_UK" wrote:

Gord,

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

Pete

Gord Dibben wrote:
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

On Mon, 16 Oct 2006 15:22:01 -0700, Patrick
wrote:

I believe this is a function of Excel, not the print driver.
Can someone confirm?

"MsDaisey" wrote:

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 MS Excel MVP