How do I arrange worksheets alphabetically in Excel?

[Rosa]

How do I arrange worksheets alphabetically in Excel?

 

[Dave Peterson]

You can click and drag them by the tabs and move them to their rightful
locations--or you could run 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

 

[Jim Cone]

Drag each sheet to the position desired.
or
Use VBA code to do it. Chip Pearson has some here...
http://www.cpearson.com/excel/sortws.htm
or
The free Excel add-in XL Extras will sort sheets ascending or
descending plus do some other nice stuff.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"Rosa" <[email protected]>
wrote in message
How do I arrange worksheets alphabetically in Excel?