Dragging and Dropping Data from Word to Microsoft Excel

 Last reviewed: February 6, 1998
Article ID: Q124999
The information in this article applies to:
  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
  • Microsoft Excel for Windows, versions 5.0, 5.0a, 5.0c

When you move or copy information from Microsoft Word to Microsoft Excel, the result in Microsoft Excel will vary depending on what is active in the worksheet. The following behavior occurs whether you are using the drag-and- drop method or the Paste Special command:

  • If a cell in the Microsoft Excel worksheet is active when the Word data is moved or copied into Excel, the Word data is inserted as text into the selected cell.
  • If a Microsoft Excel chart or drawing object is active when the data is pasted into Microsoft Excel, the selection is inserted as a Word Document Object.
  • If the Word data is a graphic, it is inserted into Microsoft Excel as a Word Document Object, regardless of what is active in Microsoft Excel.

KBCategory:
KBSubcategory:
Additional reference words: 6.0 6.0a 6.0c winword 5.0 5.0a 5.0c ole2
word6
Keywords : kbole
Version : 6.0 6.0a 6.0c
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 6, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.