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" <gracebakky@discussions.microsoft.com> wrote in message
news:019CCF9B-28B4-4606-A138-076E71CE120B@microsoft.com...
>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