alphabetizing workbook tabs

[leerskov]

What is the procedure for alphabetizing the tabs in an excel workbook.

 

[DominicB]

Good afternoon leerskov

There is no native Excel function to handle this. Chip Pearson offers a routine here to do it via macro :

http://www.cpearson.com/excel/sortws.htm

Alternately, my add-in available to download via the link below will do it for you (either alpha, reverse alpha, custom or strict numeric (eg Sheet1 is placed where it is supposed to be, not 'twixt Sheet1 and Sheet2 which is where most routines place it).

HTH

DominicB

EDIT : Just seen question 2 : use Ctrl + ;