This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2007/2008

Working with Groups of Worksheets

Grouping your worksheets can help improve consistency and save time. Once sheets are grouped, you can format or print the entire group.

return to topGrouping Worksheets

  1. Click the SHEET tab of the first sheet to be grouped
    Sheet tabs

  2. Windows: To select non-contiguous sheets, press [Ctrl] + click the sheets to be grouped
    Macintosh: To select non-contiguous sheets, press [command key] + click the sheets to be grouped
    To select contiguous sheets, press [Shift] + click the last sheet to be grouped

  3. When all the sheets of the group are selected, release the [Shift] or [Ctrl] key
    The selected worksheets are grouped.
    NOTES:
    The tabs of the grouped sheets will appear white. Unselected sheets' tabs will remain unchanged (colors may differ based on your windows color scheme).
    The notation [Group] appears next to the filename.
    Title bar showing Group notation

return to topUngrouping Worksheets

When you are finished working with your sheet groups, you will need to ungroup them.

Ungrouping Worksheets: All Sheets

  1. Windows: Right click one of the SHEET tabs within the group » select Ungroup Sheets
    Macintosh: Press [Ctrl] + click one of the SHEET tabs within the group » select Ungroup Sheets
    All grouped worksheets are ungrouped.

Ungrouping Worksheets: Individual Sheets

  1. Windows:Press [Ctrl] + click the SHEET tab of the sheet to be removed from the group
    Macintosh: Press [command key] + click the SHEET tab of the sheet to be removed from the group
    The selected worksheet is removed from the group.

return to topFormatting 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:

To format groups of sheets, use the following instructions:

  1. Group the worksheets

  2. On the current worksheet, select the cell(s) to be formatted

  3. Using the Formatting toolbar or the Format menu, apply the appropriate formatting
    NOTE: For more information about formatting options, refer to Formatting Cells (Win | Mac).

  4. Repeat steps 2–3 as necessary

  5. Ungroup the worksheets

return to topPrinting 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.

  1. Group the worksheets

  2. Windows: Click the OFFICE BUTTONOffice Button» select Print
    Macintosh: From the File menu, select Print...
    The Print dialog box appears.

  3. In the Print what section, select Active Sheets

  4. Adjust print settings as necessary
    NOTE: For more information about printing, refer to Printing Basics (Win | Mac).

  5. Click OK
    The selected worksheets are printed.

  6. Ungroup the worksheets

Excellence. Our Measure. Our Motto. Our Goal.