Microsoft KB Archive/60981

Word: Copying a Portion of an Excel Worksheet into Word PSS ID Number: Q60981 Article last modified on 08-17-1993 PSS database name: APpsConV

4.00

MACINTOSH

Summary:

When an area of a worksheet created in Microsoft Excel version 1.50 is copied to Microsoft Word version 4.00, the information appears as tab-delimited text. With Excel version 2.20, the data appears in the form of a table.

If a table has already been created and formatted in the Word document, you can copy the Excel 1.50 data and paste it directly into the existing table, as follows:

  In Excel, select and copy the data to be transferred.   In Word, select the entire table (press OPTION+double click on a cell). Choose Paste from the Edit menu. The table must be the same size as the selection in Excel. See More Information below. The Insert Table dialog box appears, indicating the number of columns and rows and a conversion from tab-delimited text.   Click OK. The information appears in the table in the same relative position from which it was copied. 

More Information:

The copy and paste areas must be of the same size. An error message appears stating that the sizes are different if, for example, an area three columns by two rows is copied from Excel and pasted into a Word table that contains three columns and three rows.

For more information on the Insert Table command, see page 141 of the “Reference to Microsoft Word” version 4.0 manual.

Additional reference words: mswdtable

Copyright Microsoft Corporation 1993.