| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| Can you sort sheet tabs in a workbook | Excel Discussion (Misc queries) | |||
| printing multiple sheet tabs to image file | Excel Discussion (Misc queries) | |||
| Sheet Tabs | Excel Discussion (Misc queries) | |||
| Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Linear Mode
