Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Right margin

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott - 21 Mar 2008 18:13 GMT
I am using Office Excel 2003 and discovered an error regarding different
margins for header and body.  I set the margin in page setup but I notice
the right margin for the contents in the right position of header is
different from the right margin of the body.  The margin for the header is
larger than that of the body.  Can someone advise me how to make them in
line.

Thanks,

Scott
Gord Dibben - 21 Mar 2008 22:06 GMT
The right edge margin of the right header/footer is set at 3/4 inch.

You cannot change that.

Same for left edge margin of left header/footer.

You can squoosh them inwards by padding with spaces, but that's all the
adjustment you have.

Gord Dibben  MS Excel MVP

>I am using Office Excel 2003 and discovered an error regarding different
>margins for header and body.  I set the margin in page setup but I notice
[quoted text clipped - 6 lines]
>
>Scott
Scott - 22 Mar 2008 01:34 GMT
> The right edge margin of the right header/footer is set at 3/4 inch.
>
[quoted text clipped - 6 lines]
>
> Gord Dibben  MS Excel MVP

Gord, thanks for your advice.  Is there any reason behind or just the
limitation of Excel?  When I set the page in landscrape and try to use
maximum size and header looks ugly.

Scott

>>I am using Office Excel 2003 and discovered an error regarding different
>>margins for header and body.  I set the margin in page setup but I notice
[quoted text clipped - 6 lines]
>>
>>Scott
Gord Dibben - 22 Mar 2008 03:29 GMT
No idea why the developers imposed that limit on left and right headers/footers.

You could perhaps insert an expanded dummy row at top of print area and place
your header info in that row.

Page setup to have that row "repeat at top" if you have multiple pages to print
out.

Gord

>> The right edge margin of the right header/footer is set at 3/4 inch.
>>
[quoted text clipped - 23 lines]
>>>
>>>Scott

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.