Insert Excel Sheet in Microsoft Word  Step by Step Guide ▷ 2020

While it is true, Microsoft Office stands out for being the most recognized and used office suite in the world. Because, it has managed to cover the entire Internet market because it interrelates desktop applications, servers and services for operating systems, in a single service.

Thus, one of the most used programs of this office suite, without a doubt, it is Microsoft Word and Microsoft Excel. Which, by default, are considered the word processor and spreadsheet most important so far, respectively. Which means that, they are very useful for many users.

That is why, through their latest versions, these softwares have focused on optimizing the user experience and, therefore, it is now possible to link an Excel spreadsheet with a Word document easily. Through this post, we will teach you how to proceed correctly in those cases.

What should we keep in mind when inserting an Excel spreadsheet into Word?

Basically, a spreadsheet refers to a computer program that facilitates the execution, management and manipulation of a wide variety of complex calculations from numerical data that is stored through tables. Therefore, it is a very useful tool both for students and professionals from different fields.

This means that a spreadsheet is considered a multipurpose tool that works perfectly for carry out office activities related to data organization. Furthermore, it works to make timely decisions by creating graphical representations of the synthesized information and allows to establish strategic levels in favor of any objective.

Consequently, the possibility arises insert a spreadsheet from Excel into a Word document. Due to the great utility of these elements that, of course, they manage to enrich any digital writing in a remarkable way and they can simplify the tasks of all those users who must manage their information from a word processor and a spreadsheet, simultaneously.

Added to this, it is also necessary to take into account that, if when adding the spreadsheet in question within a Microsoft Word page you choose to do it from the “Link” option, all the modified data within Excel will also be updated within the Word document, automatically. This, as long as you use the 2016 version of the office suite. So that, any changes made will be reflected in both programs at the same time, practically.

Steps to insert a Microsoft Excel spreadsheet into Word

As we indicated previously, the possibility of adding an Excel spreadsheet in Word is very helpful for various students or professionals who must manage and edit their information from these two programs, simultaneously. However, as your requirements may be uneven, There are two ways to do it.

In that sense, both softwares focused on the productivity of their users, offer the possibility of insert a spreadsheet with the data entered in Excel to display it from Word and, apart from that, they also allow add such blank tables directly from the word processor.

Now, to begin, we will explain each of the steps to follow in order to add an Excel spreadsheet to Microsoft Word in the traditional way and with the objective that any changes made in its original program, is displayed within the Word document automatically:

  • First of all, you have to access the Excel document that contains the data to be displayed in table form. For there, copy the data range to paste in Word, either by selecting the option “Copy” or with the keyboard shortcut “Ctrl + C”.

Steps to insert a Microsoft Excel spreadsheet into Word

  • Once you have copied said element to the clipboard, it is time to open the Word document where you want to insert the spreadsheet and when you locate the insertion point, proceed to paste the same. Either through the option “Paste” or with the key combination “Ctrl + V”.

Then, it’s time to choose one of the following options during the pasting process: “Link and use target styles” or “Link and keep source formatting”:

Steps to insert a Microsoft Excel spreadsheet into Word

  • Since then, any changes made to the spreadsheet from Excel, it will be reflected in your Microsoft Word document. Also, in case you close the latter and still make a modification in Excel, they will ask you if you want the element to be updated in the linked files, once you access the Word file again and that, we recommend you answer “Yes”.

Steps to insert a Microsoft Excel spreadsheet into Word

  • If you want to edit the table from Excel directly from Word, you will have to right click on that table, select the option “Linked Spreadsheet Object” and then click on “Link Edition” to optimize its appearance.

Steps to insert a Microsoft Excel spreadsheet into Word

  • On the other hand, if instead of adding an Excel spreadsheet with the data already exposed, what you need is insert such blank file type inside Word document, there is also a practical solution for you. Fortunately, it is a method that requires a very simple process to follow and Here we show you what it is about, step by step:
  • In this case, the entire process must be carried out from Microsoft Word, exclusively. Which means that, you have to start with open any Word document to insert your Excel spreadsheet.
  • After that, locate the insertion point on a page Or, the specific area where you prefer to add the Excel type table or table.
  • Now, it’s time to click on the “Insert” tab found in the word processor options bar. There, look for the Tables group and once you press the down arrow, you have to select the option that says “Excel Spreadsheet”.

Steps to insert a Microsoft Excel spreadsheet into Word

  • After doing the above, the Excel chart will be displayed in the indicated place and it is time to start adding each and every one of the data that you want to present in such a way in your Word text, with all Excel’s own tools and without leaving the word processor.

Steps to insert a Microsoft Excel spreadsheet into Word

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment