How do I arrange sheets in alphabetical order?
 

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

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

"gracebakky" wrote:

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

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

"gracebakky" wrote in message
...
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