ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i group worksheets inside a workbook into subgroups? (https://www.excelbanter.com/excel-worksheet-functions/18121-how-do-i-group-worksheets-inside-workbook-into-subgroups.html)

Legatha

How do i group worksheets inside a workbook into subgroups?
 
I am trying to group several worksheets inside my workbook together into a
group of their own. Let's say I have 30 worksheets in my workbook and I want
3 sets of 10 in each sub-group. Is that possible?

JulieD

Hi

if you have version 2002 or above you can colour code the sheet tabs ...
right mouse click on the tab and choose tab color

Cheers
JulieD

"Legatha" wrote in message
...
I am trying to group several worksheets inside my workbook together into a
group of their own. Let's say I have 30 worksheets in my workbook and I
want
3 sets of 10 in each sub-group. Is that possible?




Legatha

I only have excel 2000 for the office...thanks for your response anyway
:)

"JulieD" wrote:

Hi

if you have version 2002 or above you can colour code the sheet tabs ...
right mouse click on the tab and choose tab color

Cheers
JulieD

"Legatha" wrote in message
...
I am trying to group several worksheets inside my workbook together into a
group of their own. Let's say I have 30 worksheets in my workbook and I
want
3 sets of 10 in each sub-group. Is that possible?





JulieD

probably not worth upgrading for :)

"Legatha" wrote in message
...
I only have excel 2000 for the office...thanks for your response anyway
:)

"JulieD" wrote:

Hi

if you have version 2002 or above you can colour code the sheet tabs ...
right mouse click on the tab and choose tab color

Cheers
JulieD

"Legatha" wrote in message
...
I am trying to group several worksheets inside my workbook together into
a
group of their own. Let's say I have 30 worksheets in my workbook and
I
want
3 sets of 10 in each sub-group. Is that possible?








All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com