How can I sort or search the sheet tabs?
 

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!!

How can I sort or search the sheet tabs?
 

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...
--
HTH...

Jim Thomlinson


"spippin" wrote:

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!!

How can I sort or search the sheet tabs?
 

Is it possible to sort tabs alphabetically?

"Jim Thomlinson" wrote in message
...
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...
--
HTH...

Jim Thomlinson


"spippin" wrote:

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!!

How can I sort or search the sheet tabs?
 

You could use a macro:

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

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



Rasoul Khoshravan wrote:

Is it possible to sort tabs alphabetically?

"Jim Thomlinson" wrote in message
...
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...
--
HTH...

Jim Thomlinson


"spippin" wrote:

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!!

--

Dave Peterson