You can unprotect some cells in Excel 2007 to let you expand groups on protected worksheets.

Step by step guide to group Worksheets in Excel to apply common changes. It is useful when you need to apply the same formula, data or column.