Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tabs
If I have an Excel 2003 workbook of 40 worksheets, is there any way I could
group those into four groups of ten (or something similar)? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tabs
You can assign them colors, but you can't group them in any way.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Me" wrote in message ... If I have an Excel 2003 workbook of 40 worksheets, is there any way I could group those into four groups of ten (or something similar)? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tabs
I assumed as much, but figured I'd make sure.
The color coding idea is something to look into. Thank you. "Chip Pearson" wrote: You can assign them colors, but you can't group them in any way. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Me" wrote in message ... If I have an Excel 2003 workbook of 40 worksheets, is there any way I could group those into four groups of ten (or something similar)? Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tabs
Prefix each of your groups with a different prefix
grp1. grp2. grp3. grp4. (note periods) Then sort your worksheet tabs, much better system then trying to use color. To sort your worksheets see http://www.mvps.org/dmcritchie/excel...#sortallsheets BTW, coloring worksheet tabs became available with Excel 2002 (Excel XP) --- 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 "Me" wrote in message If I have an Excel 2003 workbook of 40 worksheets, is there any way I could group those into four groups of ten (or something similar)? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tabs
you might want to make that with two digits instead of single digit
so that you could have more than 10 (0-9) groups for sorting. grp01. grp02. grp03. grp04. (note periods) or use letters that make some sense b. k. t. w. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tabs
You could of course use a worksheet to make an index page creating hyperlinks to every page. Then you can group them however you like. It all depends on why you want to do it. -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=490878 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Tabs Missing! | Excel Discussion (Misc queries) | |||
Transfer "Tabs name" to a worksheet | Excel Discussion (Misc queries) | |||
Worksheet Tabs | Excel Discussion (Misc queries) | |||
A "Document Map" of worksheet tabs for Excel | Setting up and Configuration of Excel | |||
copying worksheet tabs | Excel Discussion (Misc queries) |