Creating a Word Document with Excel Data

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.

Copy an Excel Worksheet Range to a Word Document

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

Click the Insert menu, and then click File.

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

Click the Look In list arrow, and then select the drive and folder that contains the workbook you want to copy.

Double-click the filename of the workbook you want to copy.

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

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

Click OK.

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

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

Click the Copy button on the Standard toolbar.

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

Click the Paste button on the Standard toolbar.

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.