How to Combine Microsoft Word & Microsoft Excel to Produce a Report

by Brian Hudson

Overview

Combining data from Microsoft Word and Microsoft Excel can help you create functional, professional reports while avoiding cumbersome appendixes or multiple-file submissions. These instructions will allow you to quickly and easily combine data into a Word-generated report.
Directions

Step 1

Open up the Word document containing your report text and the Excel document containing the table, chart or graph you wish to integrate.
Step 2

In Word, determine where you want to place the Excel data and create a blank line at that point. Be sure that the insertion area allows enough room to fit the data on the page.
Step 3

In Excel, select the Excel data you wish to import, and then click the "Copy" button on the Home menu bar.
Step 4

In Word, make sure that your cursor is active at the point where you wish to insert the Excel data.
Step 5

Click "Paste" on the Home toolbar in Word. Your copied material should appear in the Word document.
Step 6

Repeat these steps as necessary to integrate additional Excel material.

2
Microsoft Word Microsoft Excel
Microsoft Word
Microsoft Excel
Excel spreadsheet data will be converted to a table in Word; it can be formatted and manipulated as a table after pasting. Charts and graphs are converted to graphics files that cannot be further altered in Word.
Excel spreadsheet data will be converted to a table in Word; it can be formatted and manipulated as a table after pasting.
Charts and graphs are converted to graphics files that cannot be further altered in Word.

Overview