XL: Err Msg: "Cannot Use That Command on Multiple Selections"

• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for the Power Macintosh, versions 5.0, 5.0a

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:

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

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

Additional query words: 8.00 97 export

Keywords : kberrmsg kbualink97 xlui
Version : WINDOWS:5.0,5.0c,7.0,97; MACINTOSH:5.0,5.0a
Platform : MACINTOSH WINDOWS
Issue type : kbhowto kbinfo