Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Cannot Drag Cells When You Use AutoFilter

XL2000: Cannot Drag Cells When You Use AutoFilter

View products that this article applies to.

This article was previously published under Q211635

↑ Back to the top

Symptoms

In Microsoft Excel, 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.

↑ Back to the top

Cause

This error message may occur when the following conditions are true:
  • You are using AutoFilter to sort a range that includes a hidden column. (To hide a column, on the Format menu, point to Column and then click Hide.)

    -and-
  • You are trying to drag a range of cells, and the location to which you are dragging the cells contains the hidden column.

↑ Back to the top

Resolution

To resolve this problem, unhide the hidden column, and then drag the cells. To unhide the column, follow these steps:
  1. Select the columns on either side of the hidden column. For example, if column G is hidden, select F and H.
  2. On the Format menu, point to Column, and then click Unhide.

    The hidden column reappears.
  3. Drag the cells that you want to move.
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.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

References

For more information about drag-and-drop editing, click Microsoft Excel Help on the Help menu, type turn on or off drag-and-drop editing and filling cells by dragging in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB211635, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 211635
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 246