Unexpected result pasting non-contiguous range from Excel into Word

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.

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.