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

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?

You could use a macro:


Zara wrote:
>
> 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...#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

Zara wrote:
>
> 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

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"
<Zara@discussions.microsoft.com>
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?