How to Copy Excel Table to Word with Gridlines (2 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

This article will show you how to copy table from Excel to Word with gridlines with proper illustrations.

Copy table from Excel to word with gridlines


How to Copy Table from Excel to Word with Gridlines: 2 Quick Ways

Let’s get introduced to our dataset first. The following table consists of some employees’ names, ages, and hometowns. Now let’s explore the following 2 techniques to copy this Excel table to MS Word with gridlines.

Now, we will copy this Excel table to MS Word with two quick and simple techniques.


1. Copy and Paste a Table Directly from Excel to Word

In this section, we will use the Copy button from the Excel ribbon and the Paste Special command in MS Word to copy a table from Excel to Word.

Step 1: Open the Excel File and Copy the Table

  • Go to the Excel file first.
  • Now, select the whole table area.
  • Press the Copy option from the Clipboard group to copy the table.

Copy and Paste from the Ribbon to Copy Table from Excel to Word

Step 2: Open a Word File and Paste the Table

  • Now, open a Word file. Choose Paste Special option from the Paste group.

Copy and Paste from the Ribbon to Copy Table from Excel to Word

  • The Paste Special window will appear.
  • Mark the Paste option and then choose Microsoft Excel Worksheet Object.
  • Finally, press OK.

Copy and Paste from the Ribbon to Copy Table from Excel to Word

  • Look at the Word file.

We’ve copied a table from Excel to Word keeping the gridlines intact.

Read More: How to Insert Excel Table into Word


2. Use Keyboard Shortcut

In this section, we will use the keyboard shortcut to copy and paste a table from an Excel file. This process will also link the Excel cell to Word for auto update.

Step 1: Open the Excel File and Copy the Table

  • First, select the Excel table area. Then, copy that by pressing Ctrl+C.

Step 2: Open the Word File and Paste It

  • Open an MS Word file.
  • Press Alt+Ctrl+V to avail of the Paste Special feature.
  • Mark the Paste link option and then choose Microsoft Excel Worksheet Object.

Keyboard Shortcut to Copy and Paste Excel Table and Link

  • Look at the Word file window now.

In this way, we copy the table from Excel into Word keeping the gridlines intact.


Copy Excel Table as an Image in Word Keeping the Gridlines Intact

So far we have learned two ways to copy an Excel table to Word file with the gridlines. Now we will learn how to copy the Excel table as an image in Word. The difference is, you can not edit such table in Word files.


1. Copy Excel Table as a Static Image

In this section, we will use the Paste Special tool to copy an Excel table as a static image.

Steps:

  • First, copy the table from the Excel file.
  • Now, enter the word file and press Alt + Ctrl + V.

  • Now, the Paste Special window appears.
  • Select Paste and then choose the Picture (Enhanced Metafile) option.

Paste Special to Copy Excel Table as a Static Image

  • Finally, press OK.

We can see that an image is added in the word file, that extracts the table info from Excel. This image is no longer linked with the Excel table.

Read More: How to Paste Excel Table into Word in Landscape


2. Use Paste Special to Copy Excel Table as a Linked Image

In this section, we will copy images into the word. But this will be linked with the Excel file. So when you make any change to the Excel file, corresponding change will be visible in the image in MS Word.

Steps:

  • First, copy the Excel table. Then, open the word file. Press Alt + Ctrl + V to avail of the Paste Special tool.

Paste Special to Copy Excel Table as a Linked Image

  • Choose the Paste Link Then, select Picture (Windows Metafile).

Paste Special to Copy Excel Table as a Linked Image

  • Finally, press the OK button.

If we double click this image, that will open the corresponding Excel file.

Read More: How to Paste Excel Table into Word Fit to Page


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, we described how to copy a table from Excel to Word with gridlines. I hope this will satisfy your needs. Please share your thoughts in the comment box.


Related Articles

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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo