Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Header & Footer margins (2003 SP2)

    When I change the margins in a workbbook, they don't change for the header and footer. There doesn't seem to be any way to do this. My default left and right margins are .75 inches. I changed the margins to .25 so I could fit the columns on one page, but the left and right headers and footers stay at .75. Also, how do I change the default margins?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Header & Footer margins (2003 SP2)

    The header and footer margins are hard-coded to be at .75 inches, they cannot be changed.

    See <post:=399,544>post 399,544</post:> about changing/setting the default page margins. (The location of the XLSTART folder mentioned there is probably Cocuments and Settings<username>Application DataMicrosoftExcelXLSTART where <username> is your Windows username.. Application Data is a hidden folder)

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Header & Footer margins (2003 SP2)

    The MS article XL2000: Left and Right-Aligned Header/Footer Text Ignores Margins has some workarounds

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Header & Footer margins (2003 SP2)

    Thanks. That worked. I didn't get an email notification of either of these replies. That's the first time that has happened. I checked my profile and there doesn't seem to be anything there that would have changed this. Has the forum software changed?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Header & Footer margins (2003 SP2)

    We've been having some problems with our SMTP (mail) server recently. If the problem persists, you can report it in the Lounge Matters forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •