how do I alphabetize by sheets in excel 2000? Is there an auto-so.

Keith 1 · Sep 9, 2005

Hi,
I am working with a class or school roster for kids and we are wanting to
alphabetize the sheets since for us each sheet has a name of a kid.

Is there a way to automatically have excel 2000 alphabetize by sheets?

thanks,
Keith

Chip Pearson · Sep 9, 2005

There is no built in way to do this. You need a VBA macro to sort
the sheets. See www.cpearson.com/excel/sortws.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

swatsp0p · Sep 9, 2005

Chip Pearson has tips for doing this on his web site:

http://www.cpearson.com/excel/sortws.htm

Good Luc

how do I alphabetize by sheets in excel 2000? Is there an auto-so.

Keith 1

Chip Pearson

swatsp0p