Paste Data as a Picture from Excel 2010 to Word 2010

Microsoft Office products, such as Word and Excel, are generally pretty compatible with one another.

If you need to get data from one program to another, there is likely a way to do it. But, in some cases, there are actually multiple ways to transfer data between the two programs.

One less-often-used method is to copy data from an Excel spreadsheet, then paste it into Microsoft Word as a picture.

If you know that you are going to be changing the formatting of the Word document but you want to keep the Excel data in its original format, then this is the best way to do it.

Additionally, it will prevent you from inadvertently altering the spreadsheet data and making it incorrect, because the data image can’t be edited.

Paste as an Image from Excel to Word

I like pasting from Excel to Word as an image because it prevents me from accidentally making data incorrect. I like to use the Find and Replace tool a lot, which can be a real problem if data pasted from Excel includes any of the info I am changing with that tool.

But if the data is in the Word document as an image, then it won’t be affected because any search or replace tools aren’t going to see it.

Step 1: Open the Word document into which you want to paste the data from Excel.

Step 2: Open the Excel file that contains the data you want to paste into Word.

Step 3: Use your mouse to highlight everything in the Excel spreadsheet that you want to add to the Word document.

Step 4: Press Ctrl + C on your keyboard to copy the highlighted data.

Step 5: Switch to the Word document, then navigate to the position in the document where you want to insert the copied data and click your mouse there once to position the cursor.

Step 6: Click the Home tab at the top of the window.

word 2010 home tab

Step 7: Click the Paste drop-down menu in the Clipboard section of the ribbon at the top of the window, then click the Picture option.

paste data as a picture from Excel to Word

Word 2010 actually has some pretty robust image editing capabilities, should you decide that you want to change something about the way your pasted image appears in the document.

For example, you can remove a background from a picture in Word. Note that this is just one of the many image editing options available to you within the program, so take some time to familiarize yourself with the menu to see what you can do in Word that you might have been doing in a different program instead.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy