Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Virginia, USA, Virginia, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page numbering starting at

    HELP!!!!! I am using Excel 2000 and want to print a bunch of worksheets but must have the page numbers start at numbers other than "1" (for example, 4!. How can I do this???

    Many thanks in advance,
    Georgette

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Page numbering starting at

    You could try the following kludge. Insert a new worksheet . If you want to start your printing at page 4, put a value in the first 3 rows (A1 to A3) of the new sheet and place a page break after each one. That gives you 3 pages. Now select that new sheet first, and then hold Ctrl and select the other sheet(s) you want to print and go to File, Print. You can then print from page 4 onwards.

    Hope that helps.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Virginia, USA, Virginia, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbering starting at

    Thanks... thought of that! It would be so easy if the Word programmers wrote the page numbering feature in Excel... :>)
    Georgette

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbering starting at

    I'm way behind on my mail but I see that no one gave you a solution.

    File/Page Setup in the Page tab on the bottom you have the option of First Page Number, which defaults Auto. You can change it to any number you like, and that will be the page number printed on the sheet.

    I hope this is still relevant.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Virginia, USA, Virginia, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbering starting at

    YES, YES!! This is exactly what I was looking for!! Many thanks!
    Georgette

Posting Permissions

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