Part IV: Using Advanced Excel Features
626
You may have noticed that Microsoft Excel Worksheet Object also appears in the Paste Special dia-
log box when you select the Paste Link option. If you paste the range using this option, the work-
book isn’t embedded in the Word document. When you double-click the object, Excel is activated
so that you can edit the workbook.Embedding a saved workbook in Word
Another way to embed an Excel workbook in a Word document is to choose Insert ➪ Text ➪
Object in Word, which displays the Object dialog box. Select the Create from File tab, click
Browse and locate the Excel document. When you click OK, a copy of the workbook is embedded
in the document. No link is created.Note
If you select the Link to File check box in the Object dialog box, you create a link to the workbook. In such a
case, double-clicking the object in Word activates Excel so that you can edit the workbook. n
Creating a new Excel object in Word
The preceding examples embed an existing workbook into a Word document. This section dem-
onstrates how to create a new (empty) Excel object in Word, which is useful if you’re creating a
report and need to insert a table of values. If those values aren’t available in an existing Excel work-
book, you can embed a new Excel object and type them.Tip
You could insert a normal Word table, but you can take advantage of Excel’s formulas and functions in an
embedded Excel worksheet. n
To create a new Excel object in a Word document, choose Insert ➪ Text ➪ Object in Word. Word
responds with the Object dialog box. Click the Create New tab, and you see a list of the types of
objects that you can create. Select Microsoft Office Excel Worksheet from the list and then click OK.Word inserts an empty Excel worksheet object into the document and activates it for you. Again,
you have full access to the Excel Ribbon, so you can enter whatever you want into the worksheet
object. After you finish, click anywhere in the Word document. You can double-click this object at
any time to make changes or additions.You can change the size of the object while it’s activated by dragging any of the sizing handles (the
little black squares and rectangles) that appear on the borders of the object.