ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Different margins for Even and Odd pages (https://www.excelbanter.com/excel-discussion-misc-queries/222765-different-margins-even-odd-pages.html)

kdags

Different margins for Even and Odd pages
 
Is it possible to make different margins for the even and odd pages?

I want to print on two sides and put it into a 3-ring binder. Therefore, I
want a larger margin on the edge with the holes punched through. I want the
rest of the sides to go as far out on the paper as possible, to maximize the
information.

Is this possible?

Shane Devenshire

Different margins for Even and Odd pages
 
Hi,

In 2007 you can have different even and odd headers and footers. But in no
version can you have different margins. The best you could do is define one
print range to be the ranges of your even pages and another one for the odd
pages. You would then run two separate print commands. And of course this
would lead to other problems, for example you would need to print on one side
only and then put the paper back in and print the other side.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kdags" wrote:

Is it possible to make different margins for the even and odd pages?

I want to print on two sides and put it into a 3-ring binder. Therefore, I
want a larger margin on the edge with the holes punched through. I want the
rest of the sides to go as far out on the paper as possible, to maximize the
information.

Is this possible?


kdags

Different margins for Even and Odd pages
 
Thank you. It seems like this would be a helpful function to have. Perhaps
I could suggest it for a later version. I can't be the only person who
prints out spreadsheets for 3-ring binders :)

"Shane Devenshire" wrote:

Hi,

In 2007 you can have different even and odd headers and footers. But in no
version can you have different margins. The best you could do is define one
print range to be the ranges of your even pages and another one for the odd
pages. You would then run two separate print commands. And of course this
would lead to other problems, for example you would need to print on one side
only and then put the paper back in and print the other side.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kdags" wrote:

Is it possible to make different margins for the even and odd pages?

I want to print on two sides and put it into a 3-ring binder. Therefore, I
want a larger margin on the edge with the holes punched through. I want the
rest of the sides to go as far out on the paper as possible, to maximize the
information.

Is this possible?



All times are GMT +1. The time now is 05:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com