ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I arrange the worksheets in my workbook alphabetically? (https://www.excelbanter.com/excel-worksheet-functions/108521-how-do-i-arrange-worksheets-my-workbook-alphabetically.html)

Kiara Parker

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)

Roger Govier

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)




Jim Cone

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