Creating a Word Document with Excel Data

graphics/microsoftoffice58.gif

A common pairing of Office programs combines Word and Excel. As you write a sales report, explain a budget, or create a memo showing distribution of sales, you often want to add existing spreadsheet data and charts to your text. Instead of re-creating the Excel data in Word, you can insert all or part of the data or chart into your Word document. You can use the File command on the Insert menu or copy and paste the information from Excel into Word. After you insert data or a chart into your word document, you can double-click the embedded Excel object to modify the data or chart.

Insert an Excel Worksheet Range to a Word Document

graphics/one_icon.jpg

Click in the Word document where you want to copy the Excel range.

graphics/two_icon.jpg

Click the Insert menu, and then click File.

graphics/three_icon.jpg

Click the Files Of Type list arrow, and then click All Files.

graphics/four_icon.jpg

Locate and select the drive and folder that contains the workbook you want to copy.

graphics/five_icon.jpg

Double-click the file name of the workbook you want to copy.

graphics/six_icon.jpg

Click Insert.

graphics/seven_icon.jpg

Click the Open Document In Workbook list arrow, and then select the worksheet you want.

graphics/eight_icon.jpg

Click the Name Or Cell Range list arrow, and then select the range or range name you want to copy.

graphics/nine_icon.jpg

Click OK.

graphics/15inf14.jpg

Did You Know?

You can name a range before pairing to make it easier . If you plan to insert part of an Excel worksheet in a Word document, name the range. This is easier to recall than the specific cell references.


Embed an Excel Chart in Word

graphics/one_icon.jpg

Open the Excel worksheet where the chart you want to use appears.

graphics/two_icon.jpg

Click the Copy button on the Standard toolbar.

graphics/three_icon.jpg

Click the Word document where you want to embed the chart.

graphics/four_icon.jpg

Click the Paste button on the Standard toolbar.

graphics/15inf15.jpg

graphics/15inf16.jpg

Did You Know?

You can import Excel data as a picture . To save disk space, you can insert Excel data as a picture. Data inserted this way becomes a table that you cannot edit. Select the data you want to import, press Shift as you click the Edit menu, click Copy Picture, and then click OK. Click in the Word document where you want to insert the picture, and then click the Paste button on the Standard toolbar. Drag the picture to a new location, or drag its resize handles to enlarge or shrink it.




Show Me. Microsoft Office Word 2003. See it Done, Do It Yourself
Show Me. Microsoft Office Word 2003. See it Done, Do It Yourself
ISBN: N/A
EAN: N/A
Year: 2002
Pages: 310

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net