"Cannot Use That Command on Multiple Selections" (141763)

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95
Microsoft Excel for Windows 5.0

This article was previously published under Q141763

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 one of the following error messages:

Cannot use that command on multiple selections

-OR-

The command you chose cannot be performed with multiple selections. Select a single range and click the command again.

CAUSE

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

Microsoft Excel 97

   AutoFormat
   Sort
   AutoFilter
   Form
   SubTotals
   Text to Columns
   Group and Outline

Microsoft Excel 5.0 and 7.0

   Delete Cells
   Insert Cells
   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:

100715 : XL: Err Msg "Command Cannot be use on Multiple Selections"

119806 : PRA: Exporting Data to MS Excel 5.0 Twice Causes Error

Modification Type:	Minor	Last Reviewed:	8/17/2005
Keywords:	kberrmsg kbhowto kbinfo kbualink97 KB141763