How to Copy Table from Excel to Word (3 Easy Ways)

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.

How to Copy Table from Excel to Word: 3 Suitable Ways

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

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 to copy the table from Excel to Word with Gridlines 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.

Read More: How to Insert Excel Table into Word with Formulas

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

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 Paste Excel Table into Word in Landscape

Download Practice Workbook

You can download the free Excel workbook from here and practice independently.

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.

Related Articles

• How to Paste Excel Table into Word Fit to Page
• How to Add Drop-Down List in Word from Excel
• How to Auto Populate Word Document from Excel
• How to Create Multiple Word Documents from Excel

<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel