how to link cells in excel with word 2010

HOW TO LINK CELLS IN EXCEL WITH WORD 2010 UPDATE

This creates a link to the source file so that whenever the Excel worksheet data changes, the Word document data will change as well. Click Browse to select the file, click the Link To File check box, and click OK.

Click Object again and in the Object dialog box, click the Create From File tab. To create the link to an Excel worksheet, add the data as an object by choosing the Insert tab and clicking Object in the Text group. But if that data is dynamic, showing, for example, changing sales totals or the current number of enrollees, and you'll be using your Word document over time - perhaps for training all new sales associates - you can link the data to your Excel worksheet so that it is updated automatically as the data changes.

Copy and paste works fine if the data you're pasting doesn't need to be updated ever again. Perhaps you are familiar with the process of linking data in a file, as opposed to doing a simple copy and paste or embedding the information. 3: Keep a link for safekeeping (and data editing) Note, however, that this change won't be reflected in the original Excel worksheet. When you click on the data you added, an Excel worksheet opens so that you can change the content displayed there. Click OK, and Word incorporates the Excel information as an object in your file. In the Object dialog box, click Browse to select the file. To embed your Excel worksheet, click the Insert tab, click Object, and then click Object again. By embedding the data instead of just copying and pasting it, you can open Excel and edit the worksheet information from within Word.

HOW TO LINK CELLS IN EXCEL WITH WORD 2010 UPDATE

Depending on what you're capturing in your worksheet, you may want to include the data in your Word document but still have the option to update it in the documnet later. 2: Embed data you're still tweakingĮxcel worksheets often contain moving pictures - they provide snapshots of businesses or projects or data as it changes over time. Either way, selecting the data in Excel, pressing Ctrl+C, and then pasting by pressing Ctrl+V in Word will do the trick. Or maybe you need a list of new employees for the report you owe HR. Perhaps you just want a couple of columns of numbers to back up your rose-colored projections for the fourth quarter. And sometimes this is exactly the technique you need. The easiest, no-brainer way to add data from any Office 2010 app to a Word document is, of course, to just copy and paste it. Here are a few tips you can share with them to help them make Excel and Word 2010 work together. Many of your end users need to use their Excel data in Word, but they often don't understand the various ways they can do it.

How to link cells in excel with word 2010