About how to transfer the table from Excel to Word
Often, users of Microsoft Office applicationsit becomes necessary to transfer a large-format spreadsheet with numerical data created in an MS Excel spreadsheet to a MS Word text file editor. For example, you prepare a report on the work done in a Word, and form the digital indications in an Excel spreadsheet, and you need to insert this table into the text of the report in the Word. Often, many people try to manually create a table in a text document (the Word gives this possibility) and data from Excel cells can also be moved to the table in the Word manually. But more correctly still will transfer already ready in an Excel table in the text in a Word. At the same time, many not very experienced users have a question about how to transfer the table from Excel to Word. Let us consider the possible answers to this question in more detail.
Simple copying method
It would seem that the solution to the question of how to insertexcel to the Word, lies on the surface. It's enough to select the necessary area for the insertion of the table, select the command "Copy" on the toolbar, the table will be saved in the clipboard, go to the document in the Word, place the cursor on the place where the table should be inserted, and click "Paste" . In the Word document, a table appears from the clipboard, and all the data that was in the cells in the Excel will also be copied and pasted, the work is done. However, in practice, as a rule, everything happens a little more complicated. After all, as a result of the usual "Copy / Paste" actions, tables from Excel are inserted into the Word simply "ugly": the size of the large-format spreadsheet can significantly exceed the boundaries of the text page of the Word, and the format of the data in the cells ultimately differs from the text format in the Word. Therefore, the task - how to transfer the table from the Excel to the Word - should be done somewhat differently.
Inserting a table into a text document as a graphic object
Consider the option of copying a table into a Word asgraphic object. It should be noted that the Excel spreadsheet into the Word will be inserted as a picture, i.e. when editing data in the cells of the source table in the Excel, the inserted table in the Word will not change. The advantage of this method is that such a drawing table can be moved within the document, freely copied and pasted in the same form to another place of text, changing the size of the drawing if necessary. There are some nuances of this method, which differ depending on what version of MS Word you have installed.
How to transfer the table from Excel to Word 2003 version of MS Word
Point the cursor at the place of the text where you want itwill insert a table. On the toolbar, in the "Insert" drop-down menu, select the "Object" command. In the dialog box, click "Create from file" and click on the "Browse" button to select the excel file that contains the original table prepared for the transfer. Then click "Ok". As a result, a table from the file will be inserted into your text document as a graphic object.
MS Word 2007
Next, we'll show you how to transfer the table fromekselya in the Word if you use the version of the office package 2007. Also put the cursor in the text in the right place. On the top toolbar, select the "Insert" tab, we find the "Insert object" button in the "Text" sub-section and select the "Create from file" tab in the dialog box. Further, also through the "Browse" open the desired spreadsheet and click "Ok".
Linking a table in Excel and Word
How to transfer an excel to a Word, so that the data in thecells inserted into the document in the Word table were automatically changed, if you plan to frequently update the data in the cells of the source table in the Excel. You can use the method of linking tables when inserting from the Excel into the text in the Word. To do this, you first need to copy the required table in the excel file. Next, in the Word, using the cursor on the insertion point, select the command "Special Paste" in the toolbar in the "Home" tab, switch to "Link", and select "Microsoft Excel sheet (object)" in the "How" window. As a result, a related insertion of the table occurs. Double-clicking the mouse on the table in the Word will automatically switch to this table in the Excel, you will be able to edit. Also, if necessary, you can force the data to be updated in cells, you need to right-click on the table in the Word and select the "Update link" command.
When choosing this method, one importantmoment. In the event that the structure of the linked table will subsequently change (for example, the number of rows will be changed, the columns will be deleted, etc.), then in the transferred table in the Word its integrity will be violated, it simply "floats". Therefore, it is important that the source table in the Excel before the copying and binding is composed with clearly defined sizes - with a specific number of cells (columns and rows), and only after the table is brought into the required form, you can start copying and pasting by binding. Now you know how to transfer an excel to a Word.