Sort Tabs

Z

Zak

Please Help,

Is it possible to sort worksheet tabs by alphabetical
order?

Thanks,
Zak
 
D

Dave Peterson

You can just click on the worksheet tab and drag it to anywhere you want.

If you want to alphabetize the sheets, then both Chip Pearson and David
McRitchie have routines that can sort your worksheets.

Chip's:
http://www.cpearson.com/excel/sortws.htm

David's:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

You can also rightclick on the VCR like controls (bottom left corner) and see a
list of worksheets to choose from.

And another option: David McRitchie has a macro that creates a table of
contents with hyperlinks in that worksheet.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

David also has instructions on how to install a macro and run it at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top