MS Excel application is a very convenient tool for performing calculations and presenting tabular data. However, when preparing reporting documentation, it is often required to provide tabular information in Word format. At the same time, sometimes it is necessary to translate not only the immediate content of the information, but also the formatting of documents.
It is necessary
MS Word, MS Excel, computer
Instructions
Step 1
To translate information from a file saved in Excel format into Word, open the spreadsheet file, select the necessary cells in it, right-click and select "Copy". Then, start the MS Word program, create a blank document (as a rule, it is created automatically) and paste the fragment copied from Excel into it. In this case, the number of columns required to represent the table will appear in the created document, and each row from the Excel table will be represented as a separate row in the document.
This method is the simplest, however, when using it, the formatting of the original document is lost. In addition, further editing of such a pseudo-table created in Word will be very difficult.
Step 2
To make a table prepared in Excel look almost the same in Word, paste the copied information into the table prepared in advance. To do this, count how many columns and rows the original table has. Then, in Word, select the "Table" menu item and "Insert". Enter the number of columns and rows in the window that appears and click confirm. All other (cosmetic) settings can be done later.
Now, as in the first case, copy the desired part of the table. Then, with the mouse, select the entire table created in Word, right-click and select "Paste". All data from the original table will be neatly distributed among the empty cells of the Word table. Using the Word formatting tools, correct the incorrectly placed portions of the table.
This method is optimal for the preparation of reporting documentation, but it does not allow you to save the formulas, which will complicate the subsequent recalculation of data.
Step 3
To copy a table from Excel along with formulas and design, use not a simple, but a "special" paste. To do this, also copy the required fragment of the table, then select the "Edit" - "Paste Special" items in the Word menu. Then, select the line "Microsoft Excel sheet (object)" in the window that appears.
Pay attention to the position of the point in the lines "Insert" and "Connect". To prepare standard documentation, leave this pointer on the "Insert" line.
If you need the information in the Word document to automatically change depending on the data in the Excel table, then select the "Link" item. However, it is necessary to ensure that the Word file has constant access to the file in Excel format.
