Microsoft Excel 2003/2004
Working with Groups of Worksheets
Grouping your worksheets can help improve consistency among them and save you time. Once sheets are grouped, you can format or print the entire group.
Grouping Worksheets
-
Click the SHEET tab of the first sheet to be grouped
-
Windows: To select non-contiguous sheets, press [Ctrl] + click the sheets to be grouped
Macintosh: To select non-contiguous sheets, press [command] + click the sheets to be grouped
To select contiguous sheets, press [Shift] + click the last sheet to be grouped
NOTE: The tabs of the selected sheets will appear white. Unselected sheets' tabs will remain unchanged (colors may differ based on your windows color scheme). -
Windows: When all the sheets of the group are selected, release the [Shift] or [Ctrl] key
Macintosh: When all the sheets of the group are selected, release the [shift] or [command] key
The selected worksheets are grouped.
NOTE: The notation [Group] appears next to the filename.
Ungrouping Worksheets
When you are finished working with your sheet groups, you will need to ungroup them.
Ungrouping Worksheets: All Sheets
-
Windows: Right click one of the SHEET tabs within the group » select Ungroup Sheets
Macintosh: Press [control] + click one of the SHEET tabs within the group » select Ungroup Sheets
All grouped worksheets are ungrouped.
Ungrouping Worksheets: Individual Sheets
-
Windows: Press [Ctrl] + click the SHEET tab of the sheet to be removed from the group
Macintosh: Press [command] + click the SHEET tab of the sheet to be removed from the group
The selected worksheet is removed from the group.
Formatting Worksheet Groups
If you have multiple sheets within your workbook that require the same formatting, you can format all worksheets within a group at the same time. This option works when the worksheets have similar information in the same relative location. Many types of formatting can be done with sheet groups:
- Column width
- Shading
- Formulas and functions
- Borders
- Typing of content
To format groups of sheets, use the following instructions:
-
On the current worksheet, select the cell(s) to be formatted
-
Using the Formatting toolbar or the Format menu, apply the appropriate formatting
NOTE: For more information about formatting options, refer to Formatting Your Worksheets. -
Repeat steps 2-3 as necessary
Printing Worksheet Groups
If you have multiple sheets in your workbook and you want to print select worksheets, you can do this using worksheet groups. This method will print the active area of each sheet (A1 to the last column and row containing information) or the assigned print area. This may result in different ranges being printed for each sheet.
-
From the File menu, select Print...
The Print dialog box appears. -
In the Print what section, select Active sheet(s)
-
Adjust print settings as necessary
NOTE: For more information about printing, refer to Printing Basics. -
Windows: Click OK
Macintosh: Click PRINT
The selected worksheets are printed.
