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?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks