+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    Registered User
    Join Date
    07-14-2009
    Location
    Lamarsh
    MS-Off Ver
    Excel 2007
    Posts
    6

    Header and footer questions

    Is there a way to get rid of the space designated for a header/footer completely so as to use that space in the document? While I can expand it beyond the default space by filling it in, I cannot find a way to contract it to nil height.

    Is there a way to set up a document so that the header/footer appears only on the first page. I know I can do that by creating a new section but I want to create a template that will insert the header on the first page only and the document goes to the next page automatically without inserting the header on subsequent pages.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,477

    Re: Header and footer questions

    click first page
    go to page set up
    click different first page
    now put header in
    it will only be on first page
    Mojito connoisseur and a dabbler in Cisco
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    07-14-2009
    Location
    Lamarsh
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Header and footer questions

    Thanks for that. Any suggestions as to how to get rid of the header altogether?

  4. #4
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Header and footer questions

    What do you mean: "get rid of the header"? just don't enter anything in the header and set your top margin to suit.
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

  5. #5
    Registered User
    Join Date
    07-14-2009
    Location
    Lamarsh
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Header and footer questions

    While you can set the margin at the top, I cannot find a way to reduce the header width to zero, even if it is blank. This is what I want to accomplish.

  6. #6
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Header and footer questions

    Maybe I don't get it.

    If you're not using a header and pull the top margin all the way up, the space for the header and the space for the body will overlap. But since you're not using the header, that does not matter, does it? So there's really no need to reduce the header to zero.

    What do you want to accomplish?
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

  7. #7
    Registered User
    Join Date
    03-07-2011
    Location
    Perry, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    1

    Cool Re: Header and footer questions

    How do you highlight specific cells for a rolling header?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0