Browse » Home
Saturday, December 22, 2012
How to Format Worksheet Groups in Excel
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.