Microsoft Office Tutorials and References
In Depth Information
Linking an Object from Excel to Word
Caitlin asks you to print a copy of the letter so that she can review it before mailing out
To finish the letter and then preview and print it:
1. Move the pointer over the table to make the Table Move Handle appear above the upper-
left corner of the table, click the Table Move handle
to select the entire table, and then
click the Center button
on the Formatting toolbar to center the table on the page.
2. Scroll to the bottom of the letter, and then replace Caitlin Sheehan’s name with your own.
3. Click the Print Preview button
on the Standard toolbar to preview the letter.
4. If necessary, click the Multiple Pages button on the Print Preview toolbar, and then
select 1 x 2 Pages to view both pages of the letter. See Figure 1-19.
Preview of completed customer letter
Multiple Pages button
5. Print the letter, and then click the Close button on the Print Preview toolbar.
Trouble? If your printed letter contains a table of data instead of the pie chart, click
the Magnifier button on the Print Preview toolbar if it is selected, right-click the table,
point to Chart Object on the shortcut menu, and then click Convert to open the Convert
dialog box. Click the Activate as option button, click Microsoft Office Excel Chart, and then
click the OK button. Save the document, and then print it again.
6. Save and close the letter.
7. Exit all open programs.
You have integrated the pie chart (showing the percentage of referrals to Lifestyles) and
the growth table from Excel into the letter Caitlin created in Word. She is pleased with the
finished letter and will send it to the local hospitals as soon as the new brochure is finished.