You will always need to include an Excel sheet into your Word document and connect it to automatically update the data in the Word document when you edit the primary Excel spreadsheet during working in Microsoft office. But how to copy an excel sheet into word with gridlines? You will find the answers here.
There are several ways of copying an Excel spreadsheet into Word: connect, embed, and create a new table. Whether embedded or linked, the Excel sheet does not update automatically unless the link between the two files is manually established.
However, once connected, data is updated when modifications are found in the initial Excel sheet in the inserted or connected table.
You may also copy a new Excel file into Word, which essentially runs Excel inside Word itself, in addition to adding an existing Excel tablet.
In this article, you will get a clear idea of how to copy an excel sheet into word with gridlines.
How to copy excel sheet into word with gridlines
Method 1: Copy-Paste Method
Let’s begin with the first procedure, which consists of just copy-pasting data from Excel to Word. You can choose to include only a portion of the Excel sheet in the Word doc when you choose this method.
Step 1: First, make a selection in your Excel sheet of the region you need to use in your Word document, and then press Ctrl + C on your keyboard to copy the data of the selection.
Step 2: Enter your Word document and press Ctrl + V there to paste the data of the text box into the Word document. To link, go to the bottom right and select either Match Destination Table Style and Link to Excel or Keep Source Formatting and Link to Excel from the Paste Options menu.
There are various icons in the latest version of Word. If you hover your mouse over them, you’ll get exactly two options as before.
Step 3: your data will now be linked to the source Excel sheet. If you change the Excel file and then reopen Word, it will prompt you to update the document with the updated information from the linked documents.
Step 4: Click on Yes, then, your table will update to reflect the updated values. You can observe the changes in real-time if you open both files at a time.
All these are made possible by some intricate system, but you don’t have to be concerned about it. If you simply copy/paste without using any of the linking choices, you’ll end up with a stand-alone Excel document that won’t update when the original Excel file is changed.
You also won’t be able to change the Excel sheet in Word and get it to reflect in the Excel sheet if you use it this way. It just works in one direction. If you alter the data in Word and save all the files, you’ll see the same notice as before, indicating if you’d like to update the file from either the linked files when you open it again.
When you click on Yes, the latest data from the Excel sheet will be reloaded, overwriting any changes you may have made. You may update the original Excel sheet simply. You just have to right-click on the data and select Linked Worksheet Object, and then just click on the Edit Link from Word.
This is helpful if you have a Word document that was written by someone else and you do not know where the original Excel file is located.
Method 2: Insert Object Method
The second method of connecting an Excel file to Word is to use the Insert menu option.
Step 1: First, you have to go to the Word, and click on the Insert tab. Then, you have to click on the Object and select Object from the dropdown.
Step 2: Select the Create from File option and then click on Browse to locate and select the file.
Step 3: Once you’ve selected the file, you’ll notice two checkboxes on the right-hand side. When you want to connect the Excel sheet to the website, you must select the option Link to file.
Alternatively, if you’d like to enter the sheet without linking it to the original file, you should leave the box checked.
Following the same method as before, utilizing the Insert Object technique will import all content from the Excel sheet into Word, instead of just a part of it.
You just open the original Excel file in the Excel itself when you double-click on the Excel object (if it is linked).
Finally, go to the Tabs Insert and select Tables. Then, simply click on the Excel spreadsheet below, you can add a customized Excel table in Word.
This method is just effective when you want to start from fresh with a new Excel sheet and make modifications to it from inside Word. What is amazing about this solution is that it inserts a floating sheet and loads the whole Excel menu in Word, allowing you to write formulae and other features just like you would in Excel.
You can insert sheets, make filters, style cells, and do anything else that Excel allows you to do. This is a simple and effective way to put data into a Word doc which you can properly format with Excel rather than depending on Word tables, which are notoriously difficult to make appear decent.
Inside an Excel spreadsheet, you have to remove the Print box under the Gridlines throughout the Sheet section of the formatting tab of the ribbon.
- You have to copy a portion of the sheet to the clipboard.
- Then, you have to paste the content into your Word file as an Excel sheet Object. You have to simply click on the “Paste Special” option.
- Now, you have to select either the “Paste” or “Paste link” button there. You will find them in the dialog box of the “Paste Special” option.
- Next, you have to save all the changes and exit the document.
- You have to reopen the word document.
- Once you print the word document or the presentation, the gridlines are included in the document or presentation.
- In addition, the gridlines will be present in the print preview, as you can see in the screenshot.
Method 3: Import Excel Data into a Word Table
If you want to import data from your Excel sheet into your MS Word table., then follow the steps below:
Step 1: In Microsoft Word, create a new document or open an existing one.
Step 2: Then, you have to click on the “Insert” tab. This option is located in the “Tables” group.
Step 3: Now, you have to click on the “Table” icon. There, you have to select the “Insert Table…” option.
Step 4: Change the “Number of columns,” “Number of rows,” and “AutoFit behavior” to the values that you want to see in the table. Then, click on Ok.
Step 5: Enter your Excel file and you have to select the data which you want to import thereby using the mouse.
Step 6: Copy the range of cells that you have marked by selecting “Copy” from the context menu.
Step 7: Return to Word and select the table cells into which you want to insert the Excel data from the previous step.
Step 8: Finally, you have to right-click on your Word table and click on any option that you want to apply under the “Paste Options.”
You can easily copy an excel sheet into word with gridlines using these methods. You just have to follow the steps properly according to your operating system.