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.

Hi

This is one of the many functions offered at www.asap-utilities.com where
they have a free add-in for Excel.

Hope this helps.
Andy.

"devrim" 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.

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
=================================
"devrim" 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.

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"

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.

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

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"devrim" 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.

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
=================================
"devrim" 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.