Want to bring word processors and spreadsheets closer together?

Want to bring word processors and spreadsheets closer together ?

We have talked about the integration of various services , so let's talk about the office programs that we use constantly!

Word processors and spreadsheet programs are designed for their own special purpose , the advantages of one cannot be found in the other , but the same advantages of one can be obtained in the other!

Word , Excel , PowerPoint (or similar programs in Google Drive) can be linked to each other in many different ways. For now, let's just talk about adding a table created in a spreadsheet to Word. As you may know, the Docs and Sheets programs in Google Drive are now very close to Word and Excel. So let's talk about those two programs as well.

Our intention is that the table of data should be added to the word processor and if we change the data in the original program, the other changes should also appear in Word/Docs! All the office programs can work well integrated with each other , we should be clear about our requirement.

  Import Excel file into Word

Even in a Word document we can create a simple data table , but it cannot perform calculations as powerfully as Excel. It is better that we create the data tables in Excel and import them into the Word document from there. There are two ways to do this: to specifically copy-paste the data and another way is to ' embed ' the data .

The easiest way is to copy-paste the data. For that , select the data to be imported from Excel to Word and copy it. Now open the word document , place the cursor where you want to add this table , instead of directly pasting, right click with the mouse , check the various paste options. If we want to keep the table data linked, we get two options: Link & Use Destination Styles or Link & Keep Source Formatting. In the first option only the data table will appear , we can format it in Word and in the second option the table formatting of Excel will be retained. Now if we make any changes in the Excel table , it will also be updated in Word.

Another way to bring an Excel table into Word is to embed it. To do this , open the Word file , go to Insert Object in the title ribbon and then again to Object. Here , by clicking on Create from File , we will get an option to search our Excel file. If the Excel table is not already created , you can add data to it by adding a new Excel table called insert table. Remember that if you want to send this Word document to someone else, you should already keep the Word and Excel files in one folder and send the entire folder to someone else.

Add a spreadsheet file to Google Docs

Google Drive is also similar to Microsoft programs in bringing table data from Sheets into Docs. When copying a data table from Sheets and pasting it into Docs, it will ask whether to keep the table linked ? Yes, if we paste it, if we make any changes in the table of sheets in the future , then it will also happen in the table in the docs , we just have to keep the cursor on it , and click on the ' Updated ' button.

When you have two or three colleagues or friends working on a document, one friend only prepares the data table and the other person works on the document , it can also be done in such a way as to add those data tables with links!

It is worth remembering that when we add a data table from Excel or Sheets to Word or Docs in this way, it remains linked to the original table , but this connection is one-way. That is, if we make any changes in Excel/Sheets, it gets updated in the linked table in Word/Docs , but not vice versa. Hence , if we make any changes to the table added in Word/Docs, it does not affect the original file.

Hence , if the data table is to be kept only as a reference, then work can be done by simply adding a link to the original file in Word/Docs , but if a report is to be prepared, adding a linked table will make the work easier.