Excel 2000 worksheet tabs

[shacaf]

Hello, I have multiple tabs in my main workbook. But, I
am looking for a way, if possible, to add tabs inside a
tab. For example...Book 1 has the
tab "Administration", "Diagnostics", "Cost Centers", etc.
now under the "Administration" tab I want to put "Store
101, Store 102..." How do I do this next level?

 

[David McRitchie]

You can't do that. Suggest you add a proper prefix
to them that the will sort properly -- from what you
show that should not be a problem excel that if you have
1 digit make it 3 digits so it can be sorted alphabetically
with other 3 digit suffixes. Sorting worksheet tabs.
see SortALLsheets at
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets