Article ID: 125640 - View products that this article applies to.
This article was previously published under Q125640
For a Microsoft Excel 2002 version of this article, see 291310
For a Microsoft Excel 2000 version of this article, see 213998
For a Microsoft Excel 98 and 2001 version of this article, see 192216
When you select multiple sheets in a Microsoft Excel workbook, certain sheet-specific print settings are unavailable in the Page Setup dialog box.
When you select multiple sheets, the following options are not available on the Sheet tab of the Page Setup dialog box:
Selecting multiple sheets places the sheets in group mode. In group mode, any changes you make to one sheet affect the other sheets in that group. The commands that are not available are settings that are specific to one page; these commands are not available in group mode.
Determining Whether Sheets Are in Group ModeSheets are in group mode if one of the following conditions is true:
Grouping SheetsYou can group sheets if you press SHIFT or CTRL (COMMAND on a Macintosh computer) while you click the sheet tabs. Holding SHIFT selects all sheets in the range. Holding CTRL or COMMAND selects individual sheets and places them in a group.
Ungrouping SheetsTo ungroup sheets, use either of the following methods:
Microsoft Excel 97For more information about working with grouped sheets, click the Index tab in Microsoft Excel Help, type the following text
sheets, multiple entriesand then double-click the selected text to go to the "Enter or edit the same data on multiple worksheets" topic.
Microsoft Excel 7.0For more information about selecting multiple worksheets, click the Index tab in Microsoft Excel Help, type the following text
sheets, selectingand then double-click the selected text to go to the "Select sheets in a workbook" topic.
Microsoft Excel 5.0For an "Overview of Selecting Sheets in a Workbook," choose the Search button in Help, and type:
worksheets, selectingChoose the Show Topics button, select the topic, and choose Go To.
Article ID: 125640 - Last Review: August 15, 2005 - Revision: 1.3
Contact us for more help
Connect with Answer Desk for expert help.