Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Numbering Worksheet Pages (2002 SP3)

    I would like to know if there is any way to number pages consecutively when you use the "Rows to repeat at top" function. The "page number" is in the repeated rows. Or is the only way I can do this is to use the header/footer function?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbering Worksheet Pages (2002 SP3)

    The only method that Excel provides is in the page header or footer. You might be able to create a macro that would put page numbers in a cell, but not it the repeated rows. The repeated rows exist only once, not once for each page. Therefore, there would be no place to put the page number for more than one page.
    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Numbering Worksheet Pages (2002 SP3)

    You can make it "appear" in the "row at the top" by having the header overlap the top of the printout...

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Re: Numbering Worksheet Pages (2002 SP3)

    Sorry so late in responding, but wanted to let you know your suggestion worked perfectly. Thanks so much! I've never been disappointed when posting a question here.

Posting Permissions

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