• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Sharing Information Between ... > Creating a Word Document with Excel ...

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint