How do I arrange sheets in alphabetical order?

[Guest]

I would like to have more than 60 sheets in a excel file, but going to
particular sheet is very difficult for me. so i want to search a particular
sheet or to arrang the sheets in alphabetical order

 

[Guest]

Take a look at this web page:

http://cpearson.com/excel/sort­ws.htm

This does exactly what you want, and also has few extra features you might
find useful.

Neil
www.nwarwick.co.uk

 

[JulieD]

Hi

check out
http://www.cpearson.com/excel/sortws.htm
to sort them in alphabetical order

another "trick" is to right mouse click on the sheet selection arrows
(bottom left of screen) which will display a list of sheet names - you can
then select the one you want from there

Cheers
JulieD