Results 1 to 5 of 5
  1. #1
    SummerSplash
    Guest

    Headers and Footers

    Is it possible to have a different header or footer on the first page of an Excel 2000 document than you have on subsequent pages? If this is possible, please let me know how it works. Any help will be greatly appreciated.

  2. #2
    New Lounger
    Join Date
    Sep 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Headers and Footers

    I assume you've already considered multiple sheets - which allowing different headers for each sheet?

  3. #3
    SummerSplash
    Guest

    Re: Headers and Footers

    Thanks for your speedy response. Yes multiple sheets have been considered, but the user of this document does not wish to split his document. It will be edited and changed often, thus the end of the first page will also change frequently.

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Headers and Footers

    How about a macro that sets the footer and prints page one, then changes the footer and prints pages 2-n ?
    (I pretty sure n can be a much greater number than the actual number of pages without an error.)

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Headers and Footers

    If you don't mind the extra work of having to put a header on each page, why not use custom headers. When I use them, I just copy on that I want to repeat on several pages and paste it, but it allows me to have different ones or even a page or two with none.

Posting Permissions

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