Office 2007 Bible
by John Walkenbach, Herb Tyson, Faithe Wempen, Cary N. Prague, Michael R. Groh, Peter G. Aitken, Michael R. Irwin, Gavin Powell, Lisa A. Bucki
Excel
Although sharing work between Word and Excel often works well, differences in how the two programs operate can produce confusing results. You can address this issue by becoming aware of those differences and working to accommodate them. This section looks at Word and Excel and ways to share text, data, tables, and graphics.
Using Excel content in Word
Word offers a variety of different ways to share and exchange content with Excel:
Clipboard: Copy content to the Clipboard and then use Paste or Paste Special to insert the contents into Word or Excel. Commandment: When in doubt, use Paste Special.
Chart: Use Office 2007’s new Chart feature to create a chart inside Word using Excel’s facilities.
Object: Use Insert
Text
Object
Object
Create New or Create from File to embed all or part of an Excel worksheet into a Word document.File: Use Insert
Text
Object Text from File to insert content ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access