Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a very large workbook, incorporating about 30 worksheets. I need to
arrange these alphabetically, but can not for ths life of my find the option to do this. perhaps I am going mad, or perhaps it is not very clear, but I really need some help with this! (Excel 2003) |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Kiara
Chip Pearson has some great code at his site on how to achieve this. http://www.cpearson.com/excel/sortws.htm -- Regards Roger Govier "Kiara Parker" <Kiara wrote in message ... I have a very large workbook, incorporating about 30 worksheets. I need to arrange these alphabetically, but can not for ths life of my find the option to do this. perhaps I am going mad, or perhaps it is not very clear, but I really need some help with this! (Excel 2003) |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The free Excel add-in "Excel Extras" will sort your workbook sheets.
(right-click any sheet tab and choose Sort Sheets) It also has other helpful features. Comes with a Word.doc install/use file. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Kiara Parker" wrote in message I have a very large workbook, incorporating about 30 worksheets. I need to arrange these alphabetically, but can not for ths life of my find the option to do this. perhaps I am going mad, or perhaps it is not very clear, but I really need some help with this! (Excel 2003) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I open several worksheets from the same workbook on screen | Excel Worksheet Functions | |||
Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Appending external worksheets into existing workbook? | Links and Linking in Excel | |||
How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) |