This article will show you how to copy table from Excel to Word with gridlines with proper illustrations.
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.
Step 2: Open a Word File and Paste the Table
- Now, open a word file. Choose Paste Special option from the Paste group.
- The Paste Special window will appear.
- Mark the Paste option and then choose Microsoft Excel Worksheet Object.
- Finally, press OK.
- 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
- How to Insert an Excel Spreadsheet into Word (4 Easy Methods)
- How to Paste Excel Table into Word in Landscape (3 Easy Ways)
- Excel VBA: Open Word Document and Replace Text (6 Examples)
- How to Auto Populate Word Document from Excel (with Quick Steps)
- How to Create Multiple Word Documents from Excel (3 Easy Methods)
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.
- 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.
- 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.
- Choose the Paste Link Then, select Picture (Windows Metafile).
- 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
- How to Copy Only Text from Excel to Word (3 Quick Methods)
- How to Convert Excel to Word Labels (With Easy Steps)
- Excel VBA: Open Word Document and Paste (3 Suitable Examples)
- How to Open Word Document and Save As PDF or Docx with VBA Excel
- Transfer Data from Excel to Word Automatically (5 Methods)
- How to Put a Large Excel Table into Word (7 Easy Methods)