Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default SETUP MARGINS QUESTION

Hi
I have a 4 page worksheet
In Print preview/Setup/Margins how do I make the margins of page 4
different from the other 3?
--
Martin
©¿©¬
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default SETUP MARGINS QUESTION

I would record a macro when I changed the margins, printed the first 3 pages.

Then changed the margins and printed the 4th page.

Then I'd just rerun this macro whenever I needed to do this.

Martin, ©¿©¬, @nohere.net wrote:

Hi
I have a 4 page worksheet
In Print preview/Setup/Margins how do I make the margins of page 4
different from the other 3?
--
Martin
©¿©¬


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default SETUP MARGINS QUESTION

Separate print jobs.

You could do this via VBA but would still be two distinct print jobs.


Gord Dibben MS Excel MVP

On Fri, 11 Apr 2008 16:41:09 GMT, Martin ©¿©¬ @nohere.net wrote:

Hi
I have a 4 page worksheet
In Print preview/Setup/Margins how do I make the margins of page 4
different from the other 3?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default SETUP MARGINS QUESTION

On Fri, 11 Apr 2008 15:08:59 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Separate print jobs.
You could do this via VBA but would still be two distinct print jobs.


Thanks Dave & Gord
I thought it would be a simple job of just adjusting margins,
as I have no experience of recording a macro or VBA
I'll just put the 4th page on a different worksheet
Now that I think about it, it's easier for me, as it will probably be
a one-off
Thanks for your replies, they have helped me look at my prob
differently
--
Martin
©¿©¬
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
Margins Luly255 Excel Discussion (Misc queries) 3 January 14th 08 12:27 AM
Question about printing & margins Beth Excel Discussion (Misc queries) 0 October 9th 07 07:04 AM
Sort & Page Setup Question Bob T Excel Discussion (Misc queries) 1 October 17th 05 08:01 PM
No Margins [email protected] Excel Discussion (Misc queries) 1 August 18th 05 02:46 AM
can you set the "Page Setup" margins etc. differently for each pag Tony Excel Worksheet Functions 4 February 2nd 05 01:15 PM


All times are GMT +1. The time now is 04:55 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"