The information in this article applies to:
SYMPTOMSWhen you select multiple sheets in a Microsoft Excel workbook, certain sheet-specific print settings are unavailable in the Page Setup dialog box. MORE INFORMATION
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 is true:
-or- -or- Grouping SheetsYou can group sheets if you press SHIFT or COMMAND while you click the sheet tabs. Holding SHIFT selects all sheets in the range. Holding COMMAND selects individual sheets and places them in a group.Ungrouping SheetsTo ungroup sheets, use either of the following methods:
-or- REFERENCESFor more information about working with grouped sheets, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text worksheets, selectingand then click Show Topics. Select the "Select sheets in a workbook" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant. Additional query words: XL98
Keywords : kbprint kbdta |
Last Reviewed: January 13, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |