Product Tips
Linking Microsoft Excel Data in Your Microsoft Word DocumentsBy: New Horizons® eTips for Business/Office Professionals
|
|
Situation
Many of us create numerical reports using Excel spreadsheets. Unfortunately, numbers don't always speak for themselves. You can make Excel spreadsheets more comprehensible by accompanying them with a written interpretation in the form of a Word document. However, this solution leaves you with two separate files: a Word document that contains the theory and summary of the spreadsheet values and an Excel spreadsheet that contains the calculations and values themselves.
Response
A simpler alternative is to incorporate the key numerical figures--the bottom line, so to speak - from the Excel spreadsheet in your Word document. You can configure pasted Excel data to update automatically in your Word document using Word's Paste Link feature.
How to Do It
Copy the data from the Excel spreadsheet that you want in your Word document. Switch to Word and place the insertion point where you'd like the linked object to appear. Choose Edit > Paste Special from the Word menu bar and select the Paste Link option. Select Microsoft Excel Worksheet Object from the [Paste Link] "As" list box, and then click OK. The data you selected appears in the Word document.
To manually update the link from Word, choose Edit > Links and click the Update Now button, then click OK.
Style Notes. To change the wrapping style around the linked data, right-click on it and select Format Object from the shortcut menu. In the Format Object dialog box, click on the Layout tab. Select a wrapping style from the Wrapping Style area and click OK. Then, drag the object to its final location.
Editor's Note: Copyright© 2008 New Horizons Worldwide, Inc. All rights reserved. Adapted with permission.
We thank the team at New Horizons Computer Learning Centers for permission to share this tip with you, recently published in its eTips newsletter.
To subscribe to free tips and tricks from New Horizons Computer Learning Centers, go to www.NewHorizons.com and click on Tips and Tricks."
Last Updated: 04/16/2008
