How to Copy from Excel to Word Without Losing Formatting: 4 Methods

Use Copy and Paste Feature

Another great way to keep the format of the Excel file intact in the Word file is to create a static or dynamic image of the data.

3.1 As a Static Image in Word

To insert a table in your Word document without further change in the table, you can insert a static image of the table in your Word file. Just follow the steps below.

Steps:

Select and then copy the Data table in Excel by pressing CTRL+C.

Use Insert Object Feature of MS Word

Put the cursor in your Word file to insert the data table. Go to the Home tab > Click on Paste dropdown >Paste Special. A Paste Special dialog box will appear.

Use Insert Object Feature of MS Word

The Paste section is selected, choose the Picture (Enhanced Metafile) from the list. Click OK.

Use Insert Object Feature of MS Word

Look at the following image. It’s clear the table is in the picture format here.

Use Insert Object Feature of MS Word (Result)

3.2 As a Linked Image in Word

By applying this magic trick, if you change anything in your Excel file, it will be updated in the image in the Word file. Just follow the steps below.

Steps:

Repeat the first 2 steps discussed in the previous method.
Make sure the Paste link section is selected, then choose the Picture from the list. Click OK.

If you make any change in the source Excel file, the corresponding change will appear in this Word file too.

Method 4 – Insert a Piece of Excel Spreadsheet in Word and Copy Excel Data to It

You can work just as you do in Excel by embedding a blank Excel worksheet into your Word document. Just follow the steps below to do this.

Steps:

Go to Insert tab > under the Table dropdown menu, and select Excel Spreadsheet.

Insert a Piece of Excel Spreadsheet in Word and Copy Excel Data to It

Double-click on the spreadsheet. The Excel ribbon will be visible and you can work just as you are in the Excel program. You can insert formulas, filters, add data, etc.

Insert a Piece of Excel Spreadsheet in Word and Copy Excel Data to It

Select and copy the data from our source Excel file and paste it to this current spreadsheet in your Word file.

Insert a Piece of Excel Spreadsheet in Word and Copy Excel Data to It (Result)

Click outside the worksheet window or press the Escape key to return to your Word document.

Download Practice Workbook

Download the following Excel file for your practice.