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: Error Message: The Command You Chose Cannot Be Performed with Multiple Selections

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

View products that this article applies to.

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.

↑ Back to the top

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

↑ Back to the top

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

↑ Back to the top

Keywords: KB214266, kbprb, kbualink97, kberrmsg

↑ Back to the top

Article Info
Article ID : 214266
Revision : 3
Created on : 10/6/2003
Published on : 10/6/2003
Exists online : False
Views : 283