How to Merge Excel Data Into Word Documents
When you're compiling a report or working on a project, it's sometimes easiest to collect data in a table format via Microsoft Excel. This information can easily be transferred from Excel to a document in Microsoft Word. It's simply a matter of copying the data from a Microsoft Excel document and pasting it into a Microsoft Word document.
Open both the Microsoft Word document and the Microsoft Excel spreadsheet in separate windows on the computer screen. Bring the Excel document to the foreground.
Highlight the block of spreadsheet cells that need to be included in the Word document. Copy the cells by hitting the Control button and "C" at the same time, or by selecting the "Copy" option underneath the "Edit" menu at the top of the screen.
Bring the Word document to the foreground. Position the cursor where the Excel data should be placed in the document. Go to the "Edit" menu in the Word document and select "Paste Special."
Wait for a box entitled "Paste Special" to pop up on the screen. Select "Paste" on the left side of the box. In the center of the box, there is a menu entitled "As." Select "Microsoft Excel Worksheet Object" under this heading. Click "OK."
Scan the document. The Excel table should now be in the Word document, in the spot where the cursor had been placed.