printing duplex with different sheets on page 1 & same sheet page 2

KLUMPS

New Member
Joined
Mar 9, 2013
Messages
6
Sorry if this question has been asked before.

am using excel97.

I have dozens of worksheets all different,
I want to be able to print all these duplex
The sheets have all previously been set up as 1 page containing only the ranges required.
Odd pages should change but even pages should remain the same on all.(perhaps some reference to a single sheet through coding) but i wouldn't know how to do this tho.
is there any simples to do this?

Thanks in advance
_
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

KLUMPS

New Member
Joined
Mar 9, 2013
Messages
6
:LOL:well i guess i don't have much patience and took the easy way out and used asap utilities and some creative page breaking. I made the first worksheet 2 pages, grouped all the worksheets , re-created the back sheet in page 2 of the first worksheet and copied all the page settings to all sheets. obviously i'll not be changing pg2 again and the size of my file is now giant, as all sheets now have an extra page. if anyone does have a simpler answer please post.
For something so simple excel sure makes it hard!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,369
Messages
5,601,223
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top