XL2000: Unexpected Result Pasting Non-Contiguous Range in Word

• Microsoft Excel 2000

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.

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.

Additional query words: xl2000

Keywords : kbdta xlui
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb