How do I arrange my tabs in alphabetical order all at once?

[Guest]

I have a different sheet for each person in an Excel workbook, and I have
named them in the format: "Last Name, First". Is there a way to arrange them
all in alphabetical order at one time, or do I need to move each tab
individually?

 

[Dave Peterson]

You could use a macro:

I have a different sheet for each person in an Excel workbook, and I have
named them in the format: "Last Name, First". Is there a way to arrange them
all in alphabetical order at one time, or do I need to move each tab
individually?

 

[Dave Peterson]

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

 

[Jim Cone]

There is no built-in function to do that.
However, the free Excel add-in "Excel Extras" will do it.
Plus it can create a worksheet Table of Contents and do other nice stuff.
Comes with install/use Word.doc file.
Download from...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA

"Zara"
<[email protected]>
wrote in message
I have a different sheet for each person in an Excel workbook, and I have
named them in the format: "Last Name, First". Is there a way to arrange them
all in alphabetical order at one time, or do I need to move each tab
individually?