Linking or embedding an Excel worksheet to Word comes as a useful way to make your Word more functional. In this article, we will mention 4 methods to transfer Excel Data into Your Word file.
While Excel worksheets are great at carrying out calculations, as also displaying data in tabular format, word-processing tool such as Word are better for explaining your data to others. Better still, by extracting data from excel to Word, you can combine the best features of Excel and Word into a single document. Either, you can embed an Excel table into your Word document, or you can also insert a linked Excel object to your Word.
Method 1: Copy & Paste Cell Range
The simplest way to import cell range from Excel is to, of course, copy the tabular data in Excel and then paste it in your Word document. Certainly, it is the simplest and most convenient way to transfer data. However, using this method, information in the Word document will not change if you modify the source Excel file. The steps are shown as follows:
- Select the tabular data in the Excel worksheet, and press “Ctrl + C” to copy it.
- Go to the Word document. Press “Ctrl + V” to paste Excel data to your Word.
Method 2: Copy Cell Range but Paste as a Link
By pasting cell range in Excel to your Word as a link, you can achieve synchronous update of Excel data changes in Word. And you may refer to the steps below to carry it out:
- Select Excel worksheet data, and then press “Ctrl + C” to copy it.
- Under “Home” page in Word document, click the “Paste” and then click “Link & Keep Source Formatting” button, as the arrow points to. In this way, tabular data in the Word file will change automatically with the source Excel file.
Method 3: Embed Whole Excel File as an Object
If you insert the tabular data into Word document as an Excel object, Word will run the whole Excel worksheets when you double-click the object, and you can also use Excel commands to work with the Excel worksheet in your Word. However, embedding an Excel object in Word will not synchronize Excel information changes, either.
- Select “Insert” tab, and click “Insert Object” icon.
- In the following dialogue box, switch to “Create from File” page. And then click “Browse” to select the Excel file to be inserted.
- Find the targeted Excel file, and then click “OK”.
Method 4: Link a Whole Excel object
Word contains just a static copy of the tabular data in Excel, if you just embed an Excel worksheet to Word. Then, how to link a whole Excel object to Word files, so that Word data can be updated automatically if the information in Excel files are changed? All you have to do is to change some setting to Step 3 in Method 2. In the following dialogue box, make sure you tick the “Link to File” checkbox, in this way, you will successfully link an Excel object to Your Word document.
Method 5: Paste a Excel Cell Range Object as a Link
Another way to link Excel data to your Word is to paste link as Excel object in your Word. Also, you will be able to transfer part of the tabular data using this method.
- Select the data in Excel that you want to use in Word, and press “Ctrl+C”.
- Go to the Word document. Under “Home” page, click on the “Paste” drop-down arrow, and then select “Paste Special”.
- Choose “Paste link”, and then select “Microsoft Excel Worksheet Object” to under “As:”. Finally, click “OK”.
Importing Excel Data can Cause Word File Corruptions
While Word is a relatively perfect word processing tool, unavoidably, some program bugs do exist. Sometimes, our Word document corrupts if we do some complex operations in Word. However, there is remedy to a Word file corruption. You can take hold of a powerful recovery tool to repair word, which is capable of retrieving data from seriously damaged Word files in a jiffy.
Kelly Zhao is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including excel recovery and pdf repair software products. For more information visit www.datanumen.com