Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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)
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default 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)



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,290
Default 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)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I open several worksheets from the same workbook on screen Innovman 2006 Excel Worksheet Functions 4 June 12th 06 04:57 PM
Protecting all worksheets of a workbook neeraj Excel Discussion (Misc queries) 14 May 30th 06 09:46 PM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
Appending external worksheets into existing workbook? Xuratoth Links and Linking in Excel 5 October 4th 05 12:48 PM
How do I build a workbook from the worksheets another workbook? Rico Excel Discussion (Misc queries) 4 August 19th 05 02:04 PM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"