[Software] This is how Excel helps you to create automatic texts in Word

[SaLaH.]

Today and, probably, in the coming years, Microsoft Office is and will continue to be the most complete office suite on the market, no matter who you are. As the years have gone by, the applications that are part of Office have been linked to work practically hand in hand, just like the most recent Microsoft applications, such as Teams or To Do without going any further. One of the fruits of this integration is found in the possibility of linking Excel tables in Word.

Word allows you to add Excel tables, tables that, when updating the data, automatically transfer the updated information to the Word document where the table is located. This function is ideal when we are preparing a job or project and we do not want to manually modify the table data every time a value is updated.

Add linked tables from Excel to Word
Not only can we link data from other applications that are also part of Office, but we can also link photos to reduce the final size of the documents, an especially useful function when the file in question includes a large number of content of this type. When linking the data, they have to be stored together in the same directory, otherwise the file that needs to access it won't find it and therefore won't be able to display it.

Once we have clear the basic concepts of how linking works in Office, we are going to explain how we can add linked tables from Excel to Word. The first thing we need to do

is open both the Word document that includes the document and the spreadsheet where the table is located. Next, we select the Excel table that we want to add to the Word document. To do so, we just have to click on the first cell on the left that contains the data and drag the mouse to the last cell on the right and copy the content to the clipboard.

Next, we go to the Word document where we want to display the linked data. We place the cursor in the position where we want to include the table and click on the Paste special button. In the box that appears, click Paste Link, and then click Microsoft Excel Worksheet Object. Just above it, the name of the file will be displayed, along with the name of the sheet where the data is and the cells that are part of the table.

If the table does not fit correctly in the size of the page, we can click on one of the corners and modify the size until it fits perfectly in the width of the page.

Once we have linked the Excel table to the Word document, we save both documents and keep them in the same directory. If we change the location of the Excel data source, we need to re-create the link, otherwise the data we change won't be updated because Word won't be able to find the source.

 

Source:https://www.softzone.es/noticias/programas/tip-utilizar-tablas-excel-word/