Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting Sheets within a Workbook (2000)

    Is there a way to sort sheets within a workbook so that the tabs are displayed alphabetically? I've attached a sample (with no data) - I want to put these sheets in alpha order.

    Thanks in advance for your help!
    Dory <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sorting Sheets within a Workbook (2000)

    It is one of the things that ASAP utilities, a free add-in can do (plus 300 other things)

  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: Sorting Sheets within a Workbook (2000)

    In addition to Tony's suggestion, Chip Pearson has some code if you want to do it yourself.

    Steve

  4. #4
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Sheets within a Workbook (2000)

    Sometimes you just want to sort the sheets temporarily to find something but you don't want to permanently move all the sheets around. Navigator Utilities sheet navigator allows you to see a list of all the sheets (including hiden sheets) and allows you to sort the list alphabetically or by size (number of cells used) to make it easy to jump to the sheet you are looking for.

  5. #5
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Sheets within a Workbook (2000)

    Thank you all for your suggestions - you are the best!!

    It worked! -- Dory

Posting Permissions

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