Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inserting Page Numbers (Excel 2000)

    I have a workbook filled with various forms and information on different worksheets. Is there any way to have Excel have the page numbering start over at one at the start of every worksheet (similar to creating section breaks in word so the numbering restarts itself at the beginning of every section)?? If I print only one worksheet there's no problem and the page numbering begins at 1. However, I decide to print the entire workbook the numbering is consecutive, even in the worksheets that don't have page number formatting inserted in the header/footer section.

    Any ideas???

    Many thanks, KC [img]/forums/images/smilies/smile.gif[/img]

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

    Re: Inserting Page Numbers (Excel 2000)

    Excel does not provide for this, but you could use a macro to print each sheet.

    Sub PrintAll()
    Dim sh
    For Each sh In ActiveWorkbook.Sheets
    sh.PrintOut
    Next sh
    End Sub

    Since each sheet is printed separately, page numbering will start at 1 for each.

  3. #3
    New Lounger
    Join Date
    Aug 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting Page Numbers (Excel 2000)

    Thanks so much Hans - it worked well but since I don't have much experience working with Macros it took me some time to get it running properly. As an FYI though - I figured out a much easier way of doing this...in the page setup - if you replace "auto" with "1" in the selected sheets it will start numbering at one as well.

    Many thanks for your quick repsonse!!

    -K [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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