Microsoft KB Archive/82982

= Microsoft Knowledge Base =

Excel: Multiple Selection Pastes Incorrectly from Clipboard
Last reviewed: November 29, 1995

Article ID: Q82982

The information in this article applies to:


 * Microsoft Excel for Windows version 3.0, 4.0
 * Microsoft Excel for the Macintosh version 3.0, 4.0
 * Microsoft Excel for OS/2 version 3.0

SUMMARY
It is possible to copy and paste multiple selections between sheets in Microsoft Excel. However, if a multiple selection is copied from Microsoft Excel and pasted into another application, information from between the selected noncontiguous cells will appear.

For example, if the range A1:B1,A5:B5 (4 cells) is selected and copied, then A1:B5 (10 cells) will appear when pasted.

MORE INFORMATION
This occurs because Microsoft Excel copies only the number of rows and columns of a region copied to the clipboard. It does not specify which cells within that region were copied.

Multiple selections are created by holding down the COMMAND key (CONTROL in Excel for Windows) while selecting with the mouse. They may also be created or by choosing the Select Special and GoTo commands from the Formula menu.