Excel 2010 Bible

Part IV: Using Advanced Excel Features

624

Embedding an Excel Workbook

in a Word Document

You can embed an Excel workbook in a Word document in three ways:

l (^) Copy a range and use Word’s Paste Special dialog box.
l Open an existing Excel file using Word’s Object dialog box.
l (^) Create a new Excel workbook using Word’s Object dialog box.
The following sections cover these methods.

Embedding a workbook in Word by copying

The example in this section describes how to embed an Excel workbook (shown in Figure 29.7) in

a Word document.

FIGURE 29.7

This workbook will be embedded in a Word document.

To start, select A3:C15 and copy the range to the Clipboard. Then activate (or start) Word, open

the document in which you want to embed the range, and move the insertion point to the location

in the document where you want the table to appear. Choose Word’s Home ➪ Clipboard ➪

Paste ➪ Paste Special command. Select the Paste option (not the Paste Link option) and then

choose the Microsoft Excel Worksheet Object format. Click OK, and the range appears in the

Word document. Although it appears that only the range is embedded, the entire Excel workbook

is actually embedded.