How to Move Data From Excel to Word

Written by lily medina
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Move Data From Excel to Word
You can insert Excel charts into Word documents. (Jupiterimages/Goodshoot/Getty Images)

To move Excel data from its Excel worksheet to a Word document, you simply need to copy and paste. While pasting it, however, Word offers multiple options for how you want the pasted data to appear and work. You can keep the data's original format, convert it into a new Word table, paste as a picture or paste only the numbers, unformatted. You can also choose whether to link the data to its source worksheet; if you keep it linked, then any changes to the worksheet will also change the pasted data in the Word document.

Skill level:
Moderate

Other People Are Reading

Instructions

    Copy and Paste

  1. 1

    Open the Excel worksheet that contains the data you want to move, and open the Word document in which you want to insert the data.

  2. 2

    Select the data that you want to move by clicking and dragging the cursor until all the data is highlighted.

  3. 3

    Copy the selected data by pressing, at the same time, the "Ctrl" and "C" keys on your keyboard.

  4. 4

    Switch to the open Word document and click where you want to insert the data.

  5. 5

    Press "Ctrl" and "V" on your keyboard to paste the copied data into the Word document.

  6. 6

    Click the Paste Options button, which appears below the lower right corner of the pasted data; it displays a clipboard and the word "(Ctrl)." When you click it, it expands and shows your paste options -- the different formats you can use to display the pasted data.

  7. 7

    Choose a paste option from the Paste Options menu. Each option displays only a small graphic; hover the cursor over an option to see its name.

    From left to right, click "Keep Source Formatting" if you want the data to appear as it appeared in Excel; click "Use Destination Styles" if you want to convert it to a Word table; click "Link & Keep Source Formatting" if you want to use Excel's format and keep the data linked to the Excel worksheet; click "Link & Use Destination Styles" if you want to create a Word table that's linked to the Excel worksheet; click "Picture" if you want to paste the data as a non-editable picture file; or click "Keep Text Only" if you want to paste just the numbers, without any special formatting.

    Insert as Object

  1. 1

    Open the Excel worksheet that contains the data you want to move, and open the Word document in which you want to insert the data.

  2. 2

    Select the data that you want to move by clicking and dragging the cursor until all the data is highlighted.

  3. 3

    Copy the selected data by pressing, at the same time, the "Ctrl" and "C" keys on your keyboard.

  4. 4

    Switch to the open Word document and click where you want to insert the data.

  5. 5

    Click the "Home" tab on the Ribbon.

  6. 6

    Click the lower part of the "Paste" icon, on the far left of the Ribbon. A menu drops down; click "Paste special" to launch the Paste Special dialogue box.

  7. 7

    Click the circle by "Paste," on the left of the dialogue box, if you want to paste the data without linking it to the Excel worksheet; or click the circle by "Paste link" if you want to insert the data and keep it linked to the worksheet.

  8. 8

    Click "Microsoft Office Excel Worksheet Object" in the field marked "As" to insert the data as a table, like it appeared in Excel; click "Unformatted Text" if you want to paste only the numbers, without any formatting; or click "Picture (Enhanced Metafile)" if you want to paste the data as a non-editable picture.

  9. 9

    Click "OK" at the bottom of the Paste Special dialogue box.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.