Page 5 of 27PREVNEXT

Tables III: Manage financial tables and tables from Excel and the Web

Paste Special dialog box

Using Paste Special to paste your Excel content into Word can sometimes provide better results than the regular Paste option on the Edit menu.

To do this, on the Edit menu click Paste Special. Then, in the Paste Special dialog box, select Formatted Text (RTF) and click OK.

Note: Using the Formatted Text option will change some of the Excel formatting to Word formatting, such as applying your default table style. This option also enables text wrap in the cells of the resulting Word table, whether or not text wrap was on for the copied Excel worksheet.

Select the portion of the Excel worksheet that you want to add to your Word document and copy it as you normally would copy content (Edit menu, Copy, or CTRL+C).

In Word, place your insertion point where you want the new table to appear and simply paste (Edit menu, Paste, or CTRL+V). This paste method will work for most tables you copy from Excel into Word 2003.

However, if the results are not what you wanted, or if you are working in an earlier version of Word, use the Paste Special method instead to paste your Excel content into Word, as shown here.

You can now format your new table just as you would any Word table.

Note     In Word 2003, hidden columns and rows will not be carried over when you paste content from Excel into Word. However, in some earlier versions of Word, hidden columns or rows in the copied Excel content would appear when the default paste method was used in Word.

Page 5 of 27PREVNEXT