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.
- Select and copy the data from our source Excel file and paste it to this current spreadsheet in your Word file.
- 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.
Related Articles
- How to Extract Data from Excel to Word
- How to Link Excel Cell to Word for Automatic Update
- How to Copy and Paste from Excel to Word Without Cells
- How to Copy a Chart from Excel to Word
- How to Copy Only Text from Excel to Word
<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
