Please Help, Is it possible to sort worksheet tabs by alphabetical order? Thanks, Zak
Z Zak Jul 8, 2003 #1 Please Help, Is it possible to sort worksheet tabs by alphabetical order? Thanks, Zak
S Sal Rosario Jul 9, 2003 #2 As far as I know, by dragging and dropping them yourself. Sal www.cedrostec.com
D Dave Peterson Jul 9, 2003 #3 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
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