Donate SIGN UP

Microsoft Excel

Avatar Image
Flossy3 | 16:29 Tue 04th Apr 2006 | Technology
3 Answers

Is it possible to rearrange the sheet tabs in excel so that they run alphabetically?

Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by Flossy3. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Not sure it can be done automatically but you can Click & Drag the sheet TABS to any order you like.

Unless the latest versions have an option (will check 2003 later) - 2000 doesn't, you need to use VBA and/or a Macro. Try putting 'sort worksheets in excel' into Google - this is one result:-


http://spreadsheets.about.com/b/a/108598.htm


Question Author
Thanks very much for your help

1 to 3 of 3rss feed

Do you know the answer?

Microsoft Excel

Answer Question >>