Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sheet Numbering (Excel 97)

    Hi all,

    Is it possible in Excel to number the sheets in a workbook? i.e. if I had 4 sheets in a workbook, is there anything I can do without manually going into each sheet and numbering sheet one as page one, sheet two as page two...and so on.

    Thanks for any suggestions.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Sheet Numbering (Excel 97)

    Is your question about the names of the sheets or about how you want the sheets printed?

    If it's about printing, and each sheet has one printable page as set, with headers or footers which include the page number, and you want consecutive page numbering of the printout, select all the sheets (shift click the first and last sheet name tabs, or ctrl click each of the sheet name tabs you want printed) and print them at once.

    Automatic naming of the sheets by number is possible with some VBA code.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Lounger
    Join Date
    Apr 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sheet Numbering (Excel 97)

    Hi John,
    It's about how I want the sheets printed. Thanks for the help, your tip does exactly what I needed.

Posting Permissions

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