The Excel tables are currently widely used , as these will enable and streamline many tasks or duties of the day. In addition, this Microsoft office program is versatile that will allow you to get the general average in Excel quickly and easily . However, sometimes it is necessary to move or move the tables made in Excel to a text format such as Word, because they serve to complement the information that is reflected in these formats.
Likewise, in case you are thinking of creating a table in Excel and you must transfer it to Word, it is important that you have the latest version of the office suite, which you will find on its official Microsoft-Office page ; since this way you will avoid compatibility problems between programs and you will be able to move the table to Word without any problem.
Steps to insert a table from Excel to Word without it moving
The first thing you have to know is that inserting a table from Excel to Word is not a complicated procedure, however the difficulty of copying it in that other format will increase if the table is very long . If that happens, the table could be altered and therefore the information that is in it. To prevent that from happening you must do the following.
Step 1: Configure the Excel table
In order to be able to import the table into Word in the beginning, it must be verified that the information can be adapted on a page of the format. For that case you must do the following; You must go to Excel where you have the table and locate in the lower right part, there you will notice that there are some boxes, locate the one that says preview of the page break . By selecting this option you will see that the table will be displayed in the same section.
Later you will see that there are lines that will appear vertically and horizontally in blue. In the same way you will notice that in the watermark some letters will appear with the word “Page”, these are indicative of the page quantities in which the table will be appreciated.
That is, if you see that the file says page 1, page 2 and page 3, it is because Excel has configured the table to appear in 3 sheets, this will indicate that your table will be distorted, to avoid that you will do the following.
You will select the blue lines and drag them to the end of the sheet, thus ensuring that the entire table is displayed on the same sheet or page. To verify this, you can go to the print section and you will notice that the table will appear on a single sheet .
Step 2: Configure Word
In this case, the ideal is that the Word format is configured horizontally , that is, that the sheet has a horizontal orientation so that the table is displayed in a better way. To insert the table you will do the following, go to the Excel format and select the table and copy it in the same way as you would with an image in a Word document.
Another way to insert the table is the following, you will look for an option called paste that is in the upper left , you will select it and you will click on the special paste section; There you will see a dialog window where you will locate the section that says “Microsoft Excel object spreadsheet” and voila, when you click it, the table will be pasted automatically.
Final advice
In case, when inserting the Excel table into Word format, you notice that it is not seen correctly , don’t worry, just go to the gray-shaded edges that are at the limits of the table. You will see that you can reduce or increase the size of the table without losing its characteristics, and even to make it look better you can configure the margins so that the sheet has more space.
If you have already successfully copied the Excel table to Word without it being modified and you want to print it, it is recommended that you convert this file into PDF format; since this way you will be able to print or send the complete document without risking it being altered or modified.
