Headers, margins, and printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KimberlyC - 29 Nov 2004 18:42 GMT

I have an excel worksheet wirtten in Excel 2000.

I've set my margins on the left and right side to zero and I have a right
and left custom header on the worksheet.
When I print the worksheet..the headers are lined up with the previously set
margin or default margin settings instead of lining up with my worksheet
content. They are about an inch in on each side.
How do I move my headers over to line up with the worksheet content that is
pritned??
Thanks in advance for your help!!
Kimberly

Reply to this Message

Gord Dibben - 29 Nov 2004 19:10 GMT

Kimberly

The left and right header/footer margins are fixed and cannot be moved
outwards.

The fixed setting is usually about 3/4" in from edge of paper.

Gord Dibben Excel MVP

>I have an excel worksheet wirtten in Excel 2000.
>
[quoted text clipped - 7 lines]
>Thanks in advance for your help!!
>Kimberly

Reply to this Message

lindyloutoo - 07 Dec 2004 18:49 GMT

Can I move them in? I have a document with 1.5" on the left and 1" o
the right - I can't get it moved in... help?

> [B]Kimberly
>
[quoted text clipped - 5 lines]
>
> Gord Dibben Excel MV

-
lindylouto

Reply to this Message

Gord Dibben - 08 Dec 2004 17:34 GMT

Pad with spaces to move inwards.

i.e.

For left Footer enter a number of spaces(trial and error) then your footer
setup.

For Right Footer enter your footer setup then a number of spaces.

Gord Dibben Excel MVP

>Can I move them in? I have a document with 1.5" on the left and 1" on
>the right - I can't get it moved in... help?
[quoted text clipped - 8 lines]
>>
>> Gord Dibben Excel MVP

Reply to this Message

Rate this thread: