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

--
CarolineHedge
-----------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...fo&userid=3570
View this thread: http://www.excelforum.com/showthread.php?threadid=56240

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...#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

CarolineHedges wrote:
>
> 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
> ------------------------------------------------------------------------
> CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
> View this thread: http://www.excelforum.com/showthread...hreadid=562401

--

Dave Peterson

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