How to Format Worksheet Groups in Excel

The advantage of grouping worksheets together in Microsoft Excel 2007, is that you can format them all at the same time. This creates a uniform look to the worksheets in the group and can save you a lot of time formatting all the worksheets individually. Keep reading to find out how you can format all the worksheets in a group at the same time.

Things You'll Need

• Microsoft Excel 2007

Instructions

1. Start Microsoft Excel 2007 and open an existing workbook that contains worksheets that are grouped together to form a group.

2. Look at the sheet tabs in the lower left corner of the Excel screen. The sheet tabs that are white represent the worksheets that are part of the group.

3. Click on a white sheet tab so you bring up one of the worksheets that are in the worksheet group. It does not matter which one you choose, the formatting will be applied to all the worksheets in the group.

4. Select the cells in the worksheet that you want to apply formatting to in the selected cell on this worksheet and the other worksheets in the group.

5. Apply the formatting to the cells such as a border, shading, formula, function or column width.

6. Highlight and click on another white sheet tab to bring up another worksheet in the same group. Notice that the same cells in that worksheet have also had the same formatting applied.

7. Ungroup the worksheet group once you have finished formatting all the cells you want to format in the worksheets.