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

Method 1 – Use Copy and Paste Feature

Steps:

Select the data in the Excel workbook.
Press CTRL+C to copy the Excel data.

Place the cursor where you want to paste the data.
Press CTRL+V.
Under the Ctrl dropdown button, use the Keep Source Formatting option. It keeps any formatting you did in Excel and pastes it into Word as a table of that formatting.

Method 2 – Use Insert Object Feature of MS Word

Steps:

Open an MS Word file first.
Go to the Insert tab > click on Object drop-down from the Text group. Select the Object option. An Object window will pop up.

Click on Create from the File tab and browse to the Excel Workbook you want to embed. Select whether you want the object to be linked or not. A linked object will automatically upgrade in your Word document when the Excel worksheet is updated. If you select Display as an icon, then an icon will be created in the Word document, and whenever you click on this icon, it will open the corresponding Excel file.
Press OK.

Method 3 – Copy Data from Excel to Word as an Image

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.

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.

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

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

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.

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.