You need a VBA macro to do this. See
www.cpearson.com/excel/sortws.htm for a sample procedure.


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


"Carmen" wrote in message
...
I have many sheets in an excell spreadsheet that I need to sort
in
alphabetical order how do I do it?