Data from Excel Pasted as a Table in Word for Windows

Last reviewed: July 30, 1997
Article ID: Q51825
The information in this article applies to:
  • Microsoft Word for Windows versions 1.0, 1.1, 1.1a, 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c

SUMMARY

Data copied from a Microsoft Excel for Windows spreadsheet pastes into Microsoft Word for Windows in table format.

You can convert a table to tab-separated values, comma-separated values, or paragraphs with the following steps:

Word for Windows Versions 2.x, 6.0

  1. Position the insertion point in the table. From the Table menu, choose Select Table.

  2. From the Table menu, choose Convert Table to Text.

  3. In the Separate Text With box, select the format you want to display the text in (Paragraphs Marks, Tabs, or Comma).

  4. Choose the OK button.

Word for Windows Version 1.x

  1. Select the rows or the entire table that you want to convert. (ALT+keypad5 selects the whole table).

  2. From the Insert menu, choose Table To Text.

  3. In the Convert Text to box, select the format you want to display the text in (Paragraphs, Tab Delimited, or Comma Delimited).

  4. Choose the OK button.

The format that provides the closest semblance of columns is the Tab Delimited format. If the columns are not straight, you can reset the tabs at larger intervals to create straight columns.


KBCategory: kbinterop
KBSubcategory:
Additional query words: 1.x 2.0 2.0a winword2 word6
winword 2.0a-CD 2.0b 2.0c 6.0 6.0a 6.0c
Keywords : kbinterop
Version : 1.x 2.x 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: July 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.