Knowledge Base

"Cannot Use That Command on Multiple Selections"

Article ID: 141763

Article Last Modified on 8/17/2005

APPLIES TO

Microsoft Excel 97 Standard Edition
Microsoft Excel 95 Standard Edition
Microsoft Excel 5.0 Standard Edition

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

Additional query words: 8.00 97 export XL Err Msg

Keywords: kberrmsg kbhowto kbinfo kbualink97 KB141763

Microsoft KB Archive/141763

Contents