+ Reply to Thread
Results 1 to 4 of 4

How do I setup a header in Excel that prints only on first page?

  1. #1
    mikesam7
    Guest

    How do I setup a header in Excel that prints only on first page?

    I've created an Excel spreadsheet with a header. The spreadsheet prints on 5
    pages.
    I want the header to print on pg 1 but not pgs 2-5. Is this possible?

    Currently the header is a custom header and prints on every page. I'd prefer
    fot he header to print on pg 1 only.....

  2. #2
    Registered User
    Join Date
    08-18-2005
    Posts
    59

    RE: How do I setup a header in Excel that prints only on first page?

    You'll probably need to remove the header info from the header, and insert one (or however many you need) rows above the top of your "page 1 content", and put the header info there. Decrease the top margin of the page accordingly.

    This should do it for you. I know of no "simple" way to print something in the header fields only on the first page in Excel.

    Later,
    Excel_Geek
    http://blog.excelgeek.com/

    "...I'll do that in Excel for $50..."

  3. #3
    Ron de Bruin
    Guest

    Re: How do I setup a header in Excel that prints only on first page?

    Hi Mike

    You can do this only with a macro, see
    http://www.rondebruin.nl/print.htm#Header

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "mikesam7" <mikesam7@discussions.microsoft.com> wrote in message news:B1133D03-1489-491C-82AE-E00FA586EB65@microsoft.com...
    > I've created an Excel spreadsheet with a header. The spreadsheet prints on 5
    > pages.
    > I want the header to print on pg 1 but not pgs 2-5. Is this possible?
    >
    > Currently the header is a custom header and prints on every page. I'd prefer
    > fot he header to print on pg 1 only.....




  4. #4
    Registered User
    Join Date
    08-18-2005
    Posts
    59

    RE: How do I setup a header in Excel that prints only on first page?

    Very nice, Ron de Bruin!

+ Reply to Thread

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.6.0 RC 1