Microsoft KB Archive/141763

= "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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.