MS-Excel data into MS-Word document

Microsoft office comes with this excellent feature that allows you to insert data created in Excel into Word documents. This is helpful especially when you are using Word to create business documents such as reports and business plans. While it is an easy process, you have to be aware of your options and the limitations inherent in each of the options.

One way to do it is to insert a link to an Excel worksheet in your Word document.  For users who want to ensure that the information is updated every time a change is made to the spreadsheet, this is the way to go. However, you have to make sure that you have to re-establish the link if you move the Excel file. Also, if you plan to transport the Word file for use on another computer, you will need to remember to include the Excel file.

To insert a link to an Excel file, follow these simple steps:

1. Open both the Word document and the Excel spreadsheet.

2. In Excel, copy the range of cells you want to include (if you plan to insert more columns or rows into your spreadsheet, select the entire worksheet by clicking the box at the juncture of the row numbers and column letters).

3. In your Word document position the cursor where you would like the table inserted.

4.  On the Clipboard menu, click on the dropdown menu under Paste and select Paste Special.

5.  Click the radio button beside Paste link

6. Under the label As:, select Microsoft Excel Worksheet Object
 7. Click OK 

-AS