Microsoft KB Archive/83813

= Pasting Non-Contiguous Range to Microsoft Word =

Article ID: 83813

Article Last Modified on 11/16/2006

-

APPLIES TO


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

-



This article was previously published under Q83813



SYMPTOMS
When you copy a nonadjacent range of cells (a multiple selection) in Microsoft Excel and paste it in a Microsoft Word document, the pasted range will include the cells between the nonadjacent regions. For example, if you copy 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.



WORKAROUND
To copy a nonadjacent range to a table in Word, do the following:


 * 1) Copy the first range from Microsoft Excel.
 * 2) Activate Word and paste the range in Word.
 * 3) Activate Microsoft Excel, and select the next range to paste.
 * 4) Activate Word and place the cursor outside the table on the first line.
 * 5) Paste the data from the Clipboard.

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

Additional query words: 3.0 3.00 4.0 4.00 continuous noncontiguous noncontinuous XL

Keywords: KB83813

-

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

© Microsoft Corporation. All rights reserved.