Excel - Alphabetize and Add Color to Sheet Tabs

[jpbgolf]

Hi,

I'm using MS Excel 2000 on NT 4. Is there a way to alphabetize Excel and add color to Sheet Tabs? Some Excel files I use have many Sheets all populated with data.

Thanks in advance!

jpbgolf@gis.net

 

[tazman99]

With ExcelXP you can color the tabs with almost 50 different colors. Dont know how alphabetize.

 

[KatherineCoombs]

I'd download a free add-in called Sheet Explorer (available from

http://www.winsite.com/bin/Info?3500000036215)

which does exactly this. It shows all the sheets that you have in your workbook, you can sort them, rename them, delete them, protect, duplicate etc etc. it's freeware so go for your life.

 

[xlbo]

Cannot colour tabs on anything except XP so for 2000, no go I'm afraid

What do you mean by alphabetize...????? I presume you mean, get your tabs in alpha order - please clarify Rgds
~Geoff~

 

[Loomah]

If sorting is what you want you could do a lot worse than try this site!!

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

;-) If a man says something and there are no women there to hear him, is he still wrong?