Results 1 to 3 of 3
  1. #1
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page numbers in Excel 2000 (Page numbers)

    I have two Excel sheets. Sheet number one header goes from number 1 to 139. i would like to start page number two header at 140. Can this be done with Excel 2000? If so how do I set up the header in sheet number two to do this. Please reply.,
    Catz

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

    Re: Page numbers in Excel 2000 (Page numbers)

    The easiest way that doesn't require any modifications is:
    - Click on the tab of the first sheet, then Ctrl+click on the tab of the second sheet.
    - Print.
    The sheets will be printed in one go, and Excel will automatically adjust the page numbers.

    If you want the page numbers on the second sheet to start at 140 even if the sheet is printed by itself:
    - Activate the second sheet.
    - Select File | Page Setup...
    - Make sure that the Page tab is active.
    - Enter 140 in the "First page number" box.
    - Click OK.

  3. #3
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbers in Excel 2000 (Page numbers)

    Thanks Hans. It worked. Now i can go from sheet 1 to sheet 9 and have the page numbers follow in numerical order.
    Catz

Posting Permissions

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