How to sort Worksheet names?

D

devrim

Hi,

I wonder if there is a way to sort worksheet names from A to Z or 1 to 9 in
excel. I have a lot of worksheet and it is getting me crazy to find something.

Thanks.
 
D

Daniel CHEN

For Excel itself, there is not direct way to achieve what you want.
However, you can use VBA code to write some sub to do it.
Or you can download some free addin (if you can find one) to do what you
want.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
 
J

Jim Cone

The free Excel add-in "Excel Extras" will sort worksheet names.
Right-click a worksheet tab and select sort.
Does some other things also (but not 300).
Download from http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA



"devrim"
<[email protected]>
wrote in message
Hi,
I wonder if there is a way to sort worksheet names from A to Z or 1 to 9 in
excel. I have a lot of worksheet and it is getting me crazy to find something.
Thanks.
 
D

Daniel CHEN

If you are not familar with VBA or use add-in, try this excel utility
program:
http://www.xldatasoft.com/downloads/SortSheet.xls
which sorts all the sheets and creates a summary sheet and with link to each
individual sheet.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
 
Top