Thread: How to sort worksheets in alphabetical order (descending or ascending)?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
  
Posts: 348
Default How to sort worksheets in alphabetical order (descending or ascending)?
wrote:
Hi

Am using Excel 2003.
I am using a workbook with various worksheets named differently.

For example, I have the following worksheets in the "tabs" area:

Sheet Kiwi
Sheet Apple
Sheet Orange
Sheet Banana

How can I sort them, so that they appear to me (from left to right)
like:

Sheet Apple
Sheet Banana
Sheet Kiwi
Sheet Orange

Thanks a lot.

If you only have four sheets you can just drag the tab names to where
you want them. Otherwise, the macro approach is better.

Bill
Reply With QuoteReply With Quote