You can do this too
Download “The one essential add-in for all Excel users.'”
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
Language:
Sheets » Sort all sheets...
With this utility you can sort the sheets in your workbook.You can sort the sheets alphanumeric (text), numerically (numbers) or by their tab-color.
You can also specify to sort the sheets ascending or descending.
To be able to sort by the tab-colors you need at least Excel 2002/XP.
Video example
Screenshots
Example screenshot: Sort sheets by their value or color
Starting this utility
In the Excel menu choose: ASAP Utilities » Sheets » Sort all sheets...« Return to the list of “Sheets” tools.
| « Previous Insert sheet(s) name in selected cell(s) | Next » Create an index page with links to all sheets (clickable)... |
 - 750px - ribbon.png "Download ASAP Utitilities")
Download ASAP Utitilities
Additional keywords for this tool:
Worksheets, Charts, Tab, Tabs, Change order, Group sheets, Colour, summary-worksheet, Summarize rows or columns from several sheets, alphabetical order, sorting the tabs
Worksheets, Charts, Tab, Tabs, Change order, Group sheets, Colour, summary-worksheet, Summarize rows or columns from several sheets, alphabetical order, sorting the tabs
Follow ASAP Utilities on Facebook
© 1999-2013 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands 
Connect with us and receive our "tip of the week" at:
