Excel 2010 Bible

Chapter 29: Sharing Data with Other Office Applications

623

Embedding Word documents

To embed an empty Word document into an Excel worksheet, choose Insert ➪ Text ➪ Object in

Excel. In the Object dialog box, click the Create New tab and then select Microsoft Office Word

Document from the Object type list.

The result is a blank Word document, activated and ready for you to enter text. Notice that Word’s

Ribbon replaces Excel’s Ribbon, giving you access to all of Word’s features.

To embed a copy of an existing Word file, click the Create from File tab in the Object dialog box

and then locate the file on your hard drive. The Word document is inserted into your Excel work-

sheet. Double-click the document to display the Word Ribbon.

Embedding other types of documents

You can embed many other types of objects, including audio clips, video clips, MIDI sequences,

and even an entire Microsoft PowerPoint presentation.

Figure 29.6 shows an MP3 audio file embedded in a worksheet. Clicking the object plays the song

on the default MP3 player.

FIGURE 29.6

An MP3 file embedded in a worksheet.

Tip
Some of the object types listed in the Object dialog box can result in quite useful and interesting items when
inserted into an Excel worksheet. If you’re not sure what an object type is, try adding the object to a blank
Excel workbook to see what is available. Keep in mind that not all the objects listed in this dialog box actually
work with Excel. Attempting to use some of them may even crash Excel. n