Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I delete pages in Excel? Keeps printing blank pages at end. Jojobean Charts and Charting in Excel 1 May 31st 07 07:37 AM
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. GE Cathey Setting up and Configuration of Excel 7 May 17th 07 09:42 PM
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages... GE Cathey Excel Worksheet Functions 1 May 16th 07 08:17 PM
How to print odd pages and even pages seperately in Excel. DILNAVAS Excel Discussion (Misc queries) 1 June 14th 06 11:45 AM
How do I delete pages from an Excell template of mutiple pages pulcom123 Excel Discussion (Misc queries) 2 December 30th 05 04:41 PM


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"