Integration Unit A

Edition integrating data between word and excel table

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Link Copy Excel chart and paste into Word Embed a Word file into Excel worksheet • Ways to integrate Word and Excel: Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Integrating Data Between Integrating Word and Excel Word Table object copied from Excel Photograph copied from Excel Chart linked to Excel source chart 75% is a linked value Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Copying Data from Excel to Copying Word Word • Uses of Copy and Paste commands Uses • • Copy and paste items within a document Copy Copy and paste items between programs • Items transferred with Copy and Paste Items • Line of text, value, picture, chart • Properties of a copied object • Retains formatting of original object Retains • Independent of source (except chart) Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Copying Data from Excel to Copying Word Word • Two items collected on the Clipboard Copied items on Clipboard Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Copying Data from Excel to Copying Word Word • Picture positioned in the Word report Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Copying a Chart from Excel Copying to Word to • • • • • Use the Copy and Paste commands Excel is the source file Word is the destination file Word Pasted chart is automatically linked Pasted Effect of revising chart in source file • Linked data changes in destination...
View Full Document

Ask a homework question - tutors are online