![]() |
How do I arrange the worksheets in my workbook alphabetically?
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) |
How do I arrange the worksheets in my workbook alphabetically?
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) |
How do I arrange the worksheets in my workbook alphabetically?
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) |
All times are GMT +1. The time now is 05:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com