O'Reilly logo

Office 2007 Bible by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh, Cary N. Prague, Faithe Wempen, Herb Tyson, John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required