Data from Excel Pasted as a Table in Word for Windows

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

Last Reviewed: July 30, 1997