Clicking Sheet Tab Deselects Grouped Sheets (158063)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q158063 SYMPTOMS
In Microsoft Excel, if you have multiple sheets selected (you are in Group
Edit mode) and you click a sheet tab, all sheets except the sheet whose
tab you clicked are deselected.
CAUSE
This will occur if both of the following conditions are true:
- All sheets are selected.
-and-
- You select a sheet other than the active sheet.
This behavior is by design of Microsoft Excel.
WORKAROUND
You can quickly reselect all visible sheets by using the following steps:
Microsoft Excel for Windows- Right-click any sheet tab.
- On the shortcut menu, click Select All Sheets.
Microsoft Excel for the Macintosh- Press and hold the CONTROL key.
- Click any sheet tab and click Select All Sheets on the shortcut
menu.
Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
---|
Keywords: | kbprb kbualink97 KB158063 |
---|
|