Copying Data from Excel to Word - Exercise

Contact Us or call 1-877-932-8228
Copying Data from Excel to Word - Exercise

Copying Data from Excel to Word

Duration: 5 to 10 minutes.

In this exercise, you will copy data from Microsoft Excel to Microsoft Word.

  1. Open Copy to Word.xlsx and Pizza and Wings.docx from your Excel2013.3/Exercises folder.
  2. In Copy to Word.xlsx, copy cells A1:M7 and paste them into Pizza and Wings.docx between the two paragraphs such that the formatting is the same as in Excel and the data is linked to the Excel worksheet.

Solution:

  1. Select cells A1:M7 in Copy to Word.xlsx.
  2. On the HOME tab, in the Clipboard group, click the Copy command:Copy Command
  3. In Pizza and Wings.docx, place your cursor between the two paragraphs.
  4. On the HOME tab, in the Clipboard group, click the drop-down arrow below the Paste command:Paste Command
  5. Click the Link & Keep Source Formatting icon:Icon
  6. Note that when you change the numbers in Copy to Word.xlsx, they change in Pizza and Wings.docx as well.
Next