How to Import Excel Into MS Word

Microsoft Excel and Microsoft Word are part of a software suite that is designed to work together with ease. Because of this, the only method needed to import data from Excel to Word is to cut and paste the data you want to transfer. This allows you to be selective about what data is moved and what is left behind, which can save a lot of time after a transfer has been made.

Difficulty: Moderately Easy

Instructions

1. Select the data in Excel you want to import into Word. Click the "Copy" button on the toolbar. You can also right click on the selected data and click "Copy" on the pop-up menu.

2. Select the location in your Word document to enter the copied data. Click the "Paste" icon on the toolbar or right click and select "Paste" from the pop-up menu.

3. Click the "Paste Options" icon that appears in the lower right-hand of the pasted table. There are several selections and combinations that can be made here. The option "Link to Excel" will create a link to the original Excel spreadsheet so whenever the spreadsheet is updated, the Word document updates automatically. If you want to keep the formatting and fonts from the original Excel spreadsheet, select an option that says "Keep Source Formatting." If you want your table to match the style of your Word document, select "Match Destination Table Style." Finally, if you just want the contents of the cells without any table formatting, select "Keep Text Only."

4. Adjust the formatting of the new table to meet your needs.

Tips & Warnings

• Charts can also be imported using the same procedure.

[tonriv]

on 11/23/2009 Hello Grant. I have a doubt. You said: "The option "Link to Excel" will create a link to the original Excel spreadsheet so whenever the spreadsheet is updated, the Word document updates automatically".

I'm trying to find out how to make it "moveable". I mean, I don't want a link to the original file only, but a link to an excel file located within the same folder where I will be saving the Word doc. In websites, you would use "\XYZ\excel.xls" -the Word doc will look for the xls file in the same folder where it is located.

Is it possible to somehow do so?

Best and thanks.
TonRiv