XL2000: Error Message: The Command You Chose Cannot Be Performed with Multiple Selections (214266)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q214266

SYMPTOMS

In Microsoft Excel, if you select a range that includes nonadjacent cells and attempt to perform a command on those cells, you may receive an error message similar to the following:
The command you chose cannot be performed with multiple selections. Select a single range and click the command again.

CAUSE

The error message appears in Microsoft Excel when you use one of the following commands with a nonadjacent cell range.

AutoFormat
Sort
AutoFilter
Form
SubTotals
Text to Columns
Group and Outline

MORE INFORMATION

For additional information, please see the following articles in the Microsoft Knowledge Base:

214080 XL2000: Error Message: That Command Cannot Be Used on Multiple Selections


Modification Type:MajorLast Reviewed:10/6/2003
Keywords:kberrmsg kbprb kbualink97 KB214266