Worksheet Tabs
 

Can I group worksheet tabs and then give each group a name underneath the
existing tabs? For example I have color coded the different tabs and grouped
them accordingly. Now I want to label each group.

Hi
no you can't do this in Excel

--
Regards
Frank Kabel
Frankfurt, Germany

"TheJaxSun" schrieb im
Newsbeitrag ...
Can I group worksheet tabs and then give each group a name underneath
the
existing tabs? For example I have color coded the different tabs and
grouped
them accordingly. Now I want to label each group.

Thanks!

"Frank Kabel" wrote:

Hi
no you can't do this in Excel

--
Regards
Frank Kabel
Frankfurt, Germany

"TheJaxSun" schrieb im
Newsbeitrag ...
Can I group worksheet tabs and then give each group a name underneath
the
existing tabs? For example I have color coded the different tabs and
grouped
them accordingly. Now I want to label each group.

Workaround, place a prefix in front of the worksheet tab name
k.Keyboard Shortcuts, k.Function Keys
grp1.Books, grp1.Media, grp2.Books, grp2.Media

Then you can sort your worksheet tabs
http://www.mvps.org/dmcritchie/excel...#sortallsheets
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TheJaxSun" wrote in message ...
Can I group worksheet tabs and then give each group a name underneath the
existing tabs? For example I have color coded the different tabs and grouped
them accordingly. Now I want to label each group.

Worksheet Tabs
 

I have beed trying to do the same thing. Ideally I'd like to see a handful
of tabs on my spreadsheet that are major topics and be able to click on the
tab group to show all the tabs below that belong to that group. Sometimes
when you have one spreadsheet with 30+ worksheets things get cluttered.
Windows permits folders and subfolders, I'd like that feature in Excel too.

"TheJaxSun" wrote:

Can I group worksheet tabs and then give each group a name underneath the
existing tabs? For example I have color coded the different tabs and grouped
them accordingly. Now I want to label each group.

Worksheet Tabs
 

You can't have multiple rows of tabs, but you can organize your tabs an sort them.
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
look for the word prefixes, and to sort see
http://www.mvps.org/dmcritchie/excel...#sortallsheets
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"VA - Joe" <VA - wrote in message ...
I have beed trying to do the same thing. Ideally I'd like to see a handful
of tabs on my spreadsheet that are major topics and be able to click on the
tab group to show all the tabs below that belong to that group. Sometimes
when you have one spreadsheet with 30+ worksheets things get cluttered.
Windows permits folders and subfolders, I'd like that feature in Excel too.

"TheJaxSun" wrote:

Can I group worksheet tabs and then give each group a name underneath the
existing tabs? For example I have color coded the different tabs and grouped
them accordingly. Now I want to label each group.