Dragging and Dropping Data from Word to Microsoft Excel

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


SUMMARY

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.


Additional query words: 6.0 winword 5.0 ole2 word6

Keywords : kbole
Version : WINDOWS:5.0,5.0a,5.0c,6.0,6.0a,6.0c
Platform : WINDOWS
Issue type :


Last Reviewed: December 29, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.