MacXL: Cannot Set Print Area or Print Titles (192216)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
  • Microsoft Excel 2001 for Mac
This article was previously published under Q192216
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 97 and earlier version of this article, see 125640.

SYMPTOMS

When 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:
  • Print Area
  • Rows to repeat at top
  • Columns to repeat at left
NOTE: Menu commands that are not available are dimmed. Clicking on a menu command that is not available has no effect. Clicking the Set Print Area icon also has no effect when multiple sheets are selected.

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 Mode

Sheets are in group mode if one of the following conditions is true:
  • The word "Group" follows the workbook name in the title bar of the workbook window.

    -or-
  • When you hold down CONTROL and click any sheet tab, the command Ungroup Sheets appears on the shortcut menu.

    -or-
  • More than one sheet tab is selected.
The default color of selected sheets is white. More than one white tab indicates that more than one sheet is selected.

Grouping Sheets

You 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 Sheets

To ungroup sheets, use either of the following methods:
  • Click any sheet not included in the group. (The sheet tab of a sheet that is not selected is gray by default.) -or-

  • Hold down CONTROL and click any sheet tab, and then click Ungroup Sheets.

REFERENCES

Excel 98

For more information about working with grouped sheets, follow these steps:
  1. On the Help menu, click Contents and Index. If you are using a version of the Macintosh operating system that is earlier than 8.0, click Contents and Index on the Balloon Help menu.
  2. In Excel Help, click Index, and then type the following text:

    worksheets, selecting

  3. Click Show Topics. Click the Select sheets in a workbook topic, and then click Go To.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbprb kbprint KB192216
©2002 Microsoft Corporation. All rights reserved.