Can anyone tell me if you can alphabetize sheet tabs within a workbook?
C Cimjet Apr 2, 2008 #2 Hi Michelle I'm not to sure if this is what you want, you can rename then by double clicking on the tab but you will have to sort them by hand if need to change the order. Regards Cimjet
Hi Michelle I'm not to sure if this is what you want, you can rename then by double clicking on the tab but you will have to sort them by hand if need to change the order. Regards Cimjet
D Dave Peterson Apr 2, 2008 #3 You could run a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
You could run a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
