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

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Copy Table from Excel to Word


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.

Using Shortcut Keys to Copy Table from Excel to Word

  • Or, right-click your mouse and select Copy from the context menu to copy the table.

Copy Table from Excel to Word

  • 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.

Using Paste Special to Copy Table from Excel to Word with Gridlines as Worksheet Object

  • Later, open a word file and click Paste > Paste Special.

Select Paste Special to Copy Table from Excel to Word with Gridlines as Worksheet Object

  • After opening the Paste Special dialog box, mark the Paste link and select Microsoft Excel Worksheet Object.
  • Then just press OK.

Choose Paste Link Option to Copy Table from Excel to Word with Gridlines as Worksheet Object

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


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:

Choose Paste Option to Copy Table from Excel to Word with Gridlines as Worksheet Object

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:

Choose Paste Link Option to Copy Table from Excel to Word as Picture and Keep Formatting

A few months later, an image of the table will appear in your Word file.

Output Image of Coping Table from Excel to Word as Picture and Keep Formatting

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:

Choose Paste Option to Copy Table from Excel to Word as Picture and Keep Formatting

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

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo