Sometimes, while working with data in Excel, we often need to copy from Excel to Word without losing formatting. Although there is no built-in function in Excel to copy a whole Excel file to a Word document, you can use several techniques to do this. In this article, you will learn 4 quick Ways to copy from Excel to Word without losing formatting.
How to Copy from Excel to Word Without Losing Formatting: 4 Effective Methods
Let’s first introduce our dataset. We have a dataset in table format in an Excel worksheet. Our goal is to copy and paste it into a Word file while keeping the format intact.
1. Use Copy and Paste Feature
This is the quickest way to show Excel data in Word without losing format. Just follow the steps below to do this.
Steps:
- First of all, select the data in the Excel workbook.
- Then press CTRL+C to copy the Excel data.
- Now, open a Word document. Place the cursor where you want to paste the data.
- Press CTRL+V.
- Now, 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.
Read More: How to Transfer Data from Excel to Word Automatically
2. Use Insert Object Feature of MS Word
Inserting an Excel workbook as an Excel object places a small version of Excel into your Word document. This Excel object can involve filters, multiple Excel sheets, and other Excel features. Just follow the steps below.
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.
- Now, click on Create from the File tab and browse to the Excel Workbook you want to embed. Now, 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.
- Finally, press OK.
Read More: How to Export Data from Excel to Word
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. Follow the 2 ways below to insert an image in Word.
3.1 As a Static Image in Word
If you want 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 where you need to insert the data table. Go to the Home tab > Click on Paste dropdown > Paste Special. A Paste Special dialog box will appear.
- By making sure the Paste section is selected, choose the Picture (Enhanced Metafile) from the list. Finally, 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.
- By making sure the Paste link section is selected, then choose the Picture from the list. Finally, click OK.
Finally, here is the result. If you make any change in the source Excel file, the corresponding change will appear in this Word file too.
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.
- Now, double-click on the spreadsheet. The Excel ribbon will be visible and you can work just as you are working 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 get back to your Word document.
Read More: How to Insert an Excel Spreadsheet into Word
Download Practice Workbook
Download the following Excel file for your practice.
Conclusion
In this tutorial, I have discussed 4 handy methods to copy from Excel to Word without losing formatting. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below. Happy learning!
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!
