Can you sort the worksheets in a workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CarolineHedges - 18 Jul 2006 12:05 GMT

In my workbook I have about 70 worksheets, but I want them i
alphabetical order. Is there a quick way I can do this by selecting al
sheets and then sorting, or do I really have to go into each one and d
it manually

Reply to this Message

Dave Peterson - 18 Jul 2006 13:04 GMT

You can drag and drop manually...

or

You could use a macro:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> In my workbook I have about 70 worksheets, but I want them in
> alphabetical order. Is there a quick way I can do this by selecting all
[quoted text clipped - 6 lines]
> CarolineHedges's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35705
> View this thread: http://www.excelforum.com/showthread.php?threadid=562401

Signature

Dave Peterson

Reply to this Message

Jim Cone - 18 Jul 2006 14:23 GMT

Caroline,
Or check out the free Excel add-in "Excel Extras".
Download from (no registration required) ...
http://www.realezsites.com/bus/primitivesoftware

Signature

Jim Cone
San Francisco, USA

"CarolineHedges"
wrote in message ...
In my workbook I have about 70 worksheets, but I want them in
alphabetical order. Is there a quick way I can do this by selecting all
sheets and then sorting, or do I really have to go into each one and do
it manually?
--
CarolineHedges

Reply to this Message

Rate this thread: