| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet tabs
I have a workbook with several tabs that have been renamed with #s
corresponding to what is in each worksheet. Is there a way to sort the worksheet tabs and thus the worksheets form lowest number to highest number without dragging each tab one at a time to its correct place? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet tabs
See:
http://www.cpearson.com/excel/sortws.htm -- Gary''s Student "Dani" wrote: I have a workbook with several tabs that have been renamed with #s corresponding to what is in each worksheet. Is there a way to sort the worksheet tabs and thus the worksheets form lowest number to highest number without dragging each tab one at a time to its correct place? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet tabs
Or use the free Excel add-in "Excel Extras" to sort sheets ascending
or descending. It does other nice stuff too. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Dani" wrote in message I have a workbook with several tabs that have been renamed with #s corresponding to what is in each worksheet. Is there a way to sort the worksheet tabs and thus the worksheets form lowest number to highest number without dragging each tab one at a time to its correct place? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet tabs
This link do not work anymore.
Anybody has this sorting Add-in by any chance? Thanks, Cem "Jim Cone" wrote: Or use the free Excel add-in "Excel Extras" to sort sheets ascending or descending. It does other nice stuff too. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Dani" wrote in message I have a workbook with several tabs that have been renamed with #s corresponding to what is in each worksheet. Is there a way to sort the worksheet tabs and thus the worksheets form lowest number to highest number without dragging each tab one at a time to its correct place? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet tabs
Create your own add-in and use the code from Chip Pearson's site.
http://www.cpearson.com/excel/sortws.aspx Gord Dibben MS Excel MVP On Wed, 23 Dec 2009 13:01:01 -0800, Cem wrote: This link do not work anymore. Anybody has this sorting Add-in by any chance? Thanks, Cem "Jim Cone" wrote: Or use the free Excel add-in "Excel Extras" to sort sheets ascending or descending. It does other nice stuff too. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Dani" wrote in message I have a workbook with several tabs that have been renamed with #s corresponding to what is in each worksheet. Is there a way to sort the worksheet tabs and thus the worksheets form lowest number to highest number without dragging each tab one at a time to its correct place? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel worksheet tabs to be organized vertically in outline format | Excel Worksheet Functions | |||
| Should be able to color code or highlight Excel worksheet tabs. | Excel Worksheet Functions | |||
| repeat rows for add'l pages for tabs on a multi-tab worksheet | Excel Worksheet Functions | |||
| Transfer "Tabs name" to a worksheet | Excel Discussion (Misc queries) | |||
| A "Document Map" of worksheet tabs for Excel | Setting up and Configuration of Excel | |||
Hybrid Mode
