XL97: Cannot Drag Cells When You Use AutoFilter (182771)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q182771 SYMPTOMS
In Microsoft Excel 97, when you try to drag cells, you receive the
following error message:
The command you chose cannot be performed with multiple selections.
Select a single range and click the command again.
CAUSE
This error may occur when the following conditions are true:
- You are using AutoFilter to sort a range that includes a hidden column.
-and-
- You are trying to drag a range of cells, and the location to which you
are dragging the cells contains the hidden column.
RESOLUTION
To resolve this problem, unhide the hidden column, and then drag the cells.
For example, follow these steps:
- In a new worksheet, hide column G. To do this, select column G. Point to
Column on the Format menu, and then click Hide.
- Unhide column G. To do this, select columns F and H. Point to Column on
the Format menu, and then click Unhide.
Column G reappears.
NOTE: To unhide every column in the workbook, click the Select All Cells
button, point to Columns on the Format menu, and then click Unhide.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
REFERENCES
For more information about drag-and-drop editing, click Contents And Index
on the Help menu, click the Index tab in Microsoft Excel Help, type the
following text
and then double-click the selected text to go to the "Move or copy whole
cells" topic.
| Modification Type: | Major | Last Reviewed: | 10/22/2000 |
|---|
| Keywords: | kbbug KB182771 |
|---|
|