How can I sort or search the sheet tabs?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

spippin - 23 Oct 2006 20:49 GMT

If I have a workbook with 15 sheets, it would be nice to be able to sort them
by title or search for a specific sheet. Is there a way of doing this
without phyically looking at each tab? Thank you!!

Reply to this Message

Jim Thomlinson - 23 Oct 2006 22:23 GMT

In the bottom left hand corner beside the sheet tabs are the Scroll Arrows
used to move the tabs left and right. Right click on the Arrows and you will
get a menu of the sheet. Click more sheets if there are too many to view in
the window to get a scrolling dailog...

Signature

HTH...

Jim Thomlinson

> If I have a workbook with 15 sheets, it would be nice to be able to sort them
> by title or search for a specific sheet. Is there a way of doing this
> without phyically looking at each tab? Thank you!!

Reply to this Message

Rasoul Khoshravan - 24 Oct 2006 10:22 GMT

Is it possible to sort tabs alphabetically?

> In the bottom left hand corner beside the sheet tabs are the Scroll Arrows
> used to move the tabs left and right. Right click on the Arrows and you
[quoted text clipped - 7 lines]
>> by title or search for a specific sheet. Is there a way of doing this
>> without phyically looking at each tab? Thank you!!

Reply to this Message

Dave Peterson - 24 Oct 2006 17:19 GMT

You could use a macro:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

> Is it possible to sort tabs alphabetically?
>
[quoted text clipped - 13 lines]
> >> by title or search for a specific sheet. Is there a way of doing this
> >> without phyically looking at each tab? Thank you!!

Signature

Dave Peterson

Reply to this Message