MG5350. Duplex printing in book style not calendar style

[ajw1100]

Hi.
Probably a simple solution but am beginning to think it's me that's simple!

Using MS Excel 2010 running under Window 7 and printing to my new Canon MG5350 that does Automatic Duplex printing on both sides of the paper.

Problem.

I have 6 worksheets which are 6 months of appointments, one month per worksheet. I want to print these sheets so that on page 1 is Jan, 2 is Feb and so forth in the format of a book, i.e stapled along left side and turned as you would a book. I have the worksheets in landscape format but have also tried in portrait.

No matter what settings I try on the printer it does print months on two sides but side one is normal and side two is upside down and only usable if I staple along the top edge and fold the page over as you would a wall calendar. Like book every other page is upside down.

I have tried the instructions but need a set of instructions just to understand them!!

Any suggestions as to where the problem is (Other than me!!)

Hopefully someone here has this sorted.

Regards
Alan.

 

[The Hat]

What youre asking to do is impossible, and youre not the simple one its Canon thats stupid.

In duplex mode (portrait) the printer prints the first sheet out from the head and then pulls it back in again,
it then rotates the sheet and prints it out on the second pass from the bottom. (Perfect in Portrait mode)

That is so simple anybody can do it including your Canon printer BUT ..

When you try the same thing with a landscape printed sheet,
the printer for whatever reason also flips the text for spiral binding at the top of your sheet
(Head to toe arrangement) a real Bummer.

The option to stop this happening was never included in the Canon print driver however, thats the stupid part.

Your only option is to manually print out your sheets using the print option (odd sheets first),
put them back in your printers feed tray yourself and then print using the even numbers on the second pass.

Job done easy, who needs duplex printing when you can so easily do it yourself..

 

[Tudor]

I also use ms office 2010 with win7 and mg5350. It can be done if you pay attention to settings.

When you click File-Print there are settings available.



Click "Printer Properties" (this is for landscape)







in "Staple Side"
for Landscape select "short side stapling left"
for Portrait select "long side stapling left"



enter the margin you need for stapling



When you are done with "Printer Properties" click "ok" and you are back to File-Print.



for Lanscape select "Flip pages on short edge"
for Portrait select "Flip pages on long edge"

Important!
Make sure you select the same options for every page in the File-Print area.

 

[The Hat]

I will have agree with Tudor that when using MS Office it can and does work,
so follow his instruction exactly and your documents will print correctly.

I dont normally print using MS office so I check it out again last night and came up exactly the same solution as Tudor did,
but he has posted earlier than I did so I stand corrected sorry..

 

[ajw1100]

Gentlemen, thank you for your brilliant posts and screenshots. It would seem my printer does not like Landscape but is happy with portrait. I am sure I had your settings exactly, using short side staple and flip, the print was still top to tail.

I then tried the same settings this time using Portrait and long side staple & flip and it printed fine, both sides and the right orientation (Book style)

I think I can live with this but will persevere and go back over your instructions and try again later. I must have had something wrong!

Many thanks and Regards

Alan.

 

[The Hat]

Dont give up on it just yet,
as I said I got it wrong originally too, so this screen shot of Tudors is the main one to concentrate on.

in "Staple Side"
for Landscape select "short side stapling left"
http://www.nifty-stuff.com/forum/uploads/8048_adpagesetup.png