How to make Word and Excel print landscape orientation identically

[LMcQ]

Hi,

I have a Word document and Excel spreadsheet that are both set up as
Landscape and which are printed 2-sided. When I print the Word document, it
prints as I'd like it to - so that I can punch holes, insert in 3-ring
binder, and read the pages front and back by flipping through the binder
pages. So the even numbered pages have the holes at the top of the page, and
the odd-numbered pages have the holes at page bottom, and the tops/bottoms
are reversed in position on the even/odd pages.

But in Excel, the same printer prints the pages in a 180-degree difference,
so that to read the pages in a binder, I have to flip the binder half-way
around. In other words, the holes wind up punched at the top of each page,
regardless of which side of the paper faces up and on each side of the page,
the content is header-to-header.

Since Word prints these out OK, I'm thinking this isn't a printer-driver
issue and that there might be a way to tell Excel to spool to the printer the
same way.

Anyone have any ideas?

Thanks,
LMcQ

 

[Keme]

Hi,

I have a Word document and Excel spreadsheet that are both set up as
Landscape and which are printed 2-sided. When I print the Word document, it
prints as I'd like it to - so that I can punch holes, insert in 3-ring
binder, and read the pages front and back by flipping through the binder
pages. So the even numbered pages have the holes at the top of the page, and
the odd-numbered pages have the holes at page bottom, and the tops/bottoms

[...]

Word is a tool specifically designed for producing printed matter. As
such, it has the necessary options for, in this case, selecting "binding
edge".

Excel, on the other hand, is a calculation tool with basic printing
functions. To get more advanced print functionality you could paste the
spreadsheet into a Word document, or you could do the print handling
manually: print odd pages, turn the deck and print the even pages.
(Depending on how the printer flips the sheets before and after
printing, you may need to reverse printing sequence on one or both of
the turns, and/or print the even pages first.)