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


Download Practice Workbook

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


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

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 t 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 (8 Easy Ways)


Similar Readings


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 file with Word.

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.

Read More: How to Insert Excel Table into Word with Formulas (2 Easy Ways)


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 Copy from Excel to Word Without Losing Formatting (4 Easy Ways)


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 Copy and Paste from Excel to Word Without Cells (2 Quick Ways)


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 have a look at our website Exceldemy.com and give your suggestions in the comment box.


Related Articles

Alok Paul
Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo