After working in Excel, we often need to copy a table from an Excel worksheet to a Word file. You can think of creating the same table again in Word manually. But no need to do this boring thing, you can easily copy the table just by following some easy ways. In this article, we’ll show 3 easy methods to copy a table from Excel to Word with sharp steps and illustrations.
Download Practice Workbook
You can download the free Excel workbook from here and practice independently.
3 Suitable Ways to Copy Table from Excel to Word
First of all, get introduced to our dataset which is a table that contains the sales and profits of a company for 10 years in different regions.
1. Using Shortcut Keys to Copy Table from Excel to Word
First, we’ll learn the traditional way to copy tables from Excel to Word. For copying anything generally, we use the Ctrl + C and Ctrl + V keys. Here, we are going to follow this way actually.
Steps:
- Select the whole table.
- Then press Ctrl + C to copy.
- Or, right-click your mouse and select Copy from the context menu to copy the table.
- Then open your Word file and just press Ctrl + V.
It will paste as a plain table including formats but there will be no connection with the source data. So if you change any data, it won’t update the table.
Read More: How to Insert Excel Table into Word (8 Easy Ways)
2. Using Paste Special to Copy Table from Excel to Word with Gridlines as Worksheet Object
In this section, we’ll use the Paste Special option of Word to copy the table as a worksheet object. We can do that following two ways.
2.1 As Linked Object
First, we’ll copy it as a linked worksheet object. So whenever you change any source data it will be updated in the Word file too.
Steps:
- Select the range of the table and copy using Ctrl + C.
- Later, open a word file and click Paste > Paste Special.
- After opening the Paste Special dialog box, mark the Paste link and select Microsoft Excel Worksheet Object.
- Then just press OK.
Soon after you will get the table in your Word file.
Now if you change a value, it will be updated automatically. We changed the value of Cell E5 and it synchronized with the table in the Word file. So, if you send the word file to someone then you will have to send the Excel file too.
Similar Readings
- How to Generate a Word Document from an Excel Macro
- Transfer Data from Excel to Word Automatically (5 Methods)
- Insert an Excel Spreadsheet into Word (4 Easy Methods)
- How to Create Multiple Word Documents from Excel (3 Easy Methods)
- Excel VBA: Open Word Document and Replace Text (6 Examples)
2.2 As Static Object
If we copy without linking then it will copy the Excel table to Word with gridlines too. Basically, it will embed an Excel window within the Word file so you will get the gridlines intact. So we enabled the gridlines for this method.
Steps:
- Follow the first two steps from section- 2.1 to open the Paste Special dialog box.
- Then mark Paste and select Microsoft Excel Worksheet Object.
- Finally, just press OK.
Then you will get the table in the Word file like the image below.
- Double-click on the table. After a while, it will open an embedded Excel window into the Word File.
And look, the gridlines are also available now. Here, you can work like the actual Excel file. So, if you send the word file to someone then you won’t need to send the Excel file.
Read More: How to Put a Large Excel Table into Word (7 Easy Methods)
3. Using Paste Special to Copy Table from Excel to Word as Picture and Keep Formatting
In our last method, we’ll learn how to copy tables from Excel to Word keeping the formatting as a picture. We can do it in two ways.
3.1 As Linked Picture
If we paste the table keeping the source link then the benefit is whenever we change anything that will be updated to the picture in the Word file. Let’s see how to do it.
Steps:
- Again follow the first two steps from section- 2.1 to open the Paste Special dialog box.
- Mark the Paste link and select Picture (Windows Metafile).
- Later, just press OK.
A few months later, an image of the table will appear in your Word file.
Have a look, we inserted 0 in Cell E5 and it is updated in the picture too. And the picture is keeping the formatting intact.
3.2 As Static Picture
If you prefer to keep a static picture of the table to avoid the update procedure then use the Paste option with the Picture option.
Steps:
- Follow the first two steps from section- 2.1 to open the Paste Special dialog box.
- Mark the Paste option and select Picture (Enhanced Metafile).
- Lastly, just press OK.
See, an image of the table remaining on the Word file. And when we changed a value in the Excel file then the image is remaining static.
Read More: How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
Conclusion
That’s all for the article. I hope the procedures described above will be good enough to copy a table from Excel to Word. Feel free to ask any question in the comment section and please give me feedback. Visit ExcelDemy to explore more.
Related Articles
- Link Excel Cell to Word for Automatic Update
- How to Copy a Chart from Excel to Word (2 Easy Ways)
- Copy Only Text from Excel to Word (3 Quick Methods)
- How to Convert Excel to Word Labels (With Easy Steps)
- Copy and Paste from Excel to Word Without Cells (2 Quick Ways)
- How to Open Word Document and Save As PDF or Docx with VBA Excel
- Excel VBA: Open Word Document and Paste (3 Suitable Examples)