Microsoft KB Archive/214114

= Unexpected result pasting non-contiguous range from Excel into Word =

Article ID: 214114

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214114





SYMPTOMS
When you use the Copy and Paste commands to move a non-adjacent range of cells (multiple selected) from a Microsoft Excel document to a Microsoft Word document, the pasted range will include the cells between the non-adjacent regions.

For Example: If you use the Copy command on a region from Microsoft Excel that includes cells A1:A10, C1:C10, and E1:E10, the pasted data will include entire range of A1:E10.

Note This problem also occurs when you move a non-adjacent range of cells from a Microsoft Excel document to a Notepad document or to a WordPad document.



WORKAROUND
To work around this problem, copy the non-adjacent range to a table in Word. To do this, follow these steps:
 * 1) In Microsoft Excel, select first range of cells. On the Edit menu, click Copy.
 * 2) Switch to Word. On the Edit menu, click Paste.
 * 3) Switch to Microsoft Excel, and select the next range of cells.
 * 4) Switch to Word. Place the insertion point outside of the table on the first line.
 * 5) On the Edit menu, click Paste.

The selected range will be attached to the previously created table.

Additional query words: xl2000 XL2002 xl2003

Keywords: kbprb KB214114

-

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

© Microsoft Corporation. All rights reserved.