The Excel tables are widely used today, since these allow you to perform and streamline many tasks or day-to-day tasks. At the same time, this Microsoft office program is versatile and will allow you to obtain the general average in Excel quickly and easily. Despite this, 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.
At the same time, in case you are thinking of creating a table in Excel and you have to pass it to Word, it is essential that you have the latest version of the office suite, which you will find in your official page in Microsoft-Office; what's more you will avoid compatibility problems between programs and you will be able to move the table to Word without any problem.
Steps to copy an Excel table into Word without it moving
The first thing you should know is that inserting a table from Excel to Word is not a complicated procedure, despite this the difficulty of copying it in that other format will increase if the table is very long. If that happens, the table could be modified and therefore the information it contains. To prevent that from happening, you must do the following.
Paste as table
In order to be able to import the table into Word at 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, locates the one that says preview page break. By choosing 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 number of pages in which the table will be seen.
In other words, 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 tell you that your table will be distorted, to prevent you from doing the following.
You will select the blue lines and drag them to the end of the sheet, in this way you will get the entire table to be displayed on the same sheet or page. To verify this, can go to print section and you will notice that the table will appear on a single sheet.
Paste as Excel object
For this case, the best thing is that he Word format is set to landscape, In other words, that the sheet has a horizontal orientation so that the table is better displayed. To insert the table you will do the following, go to Excel format and choose 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, will look for a option called paste found in the upper left, you will select it and 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 ready, when i click on it, the table will be pasted automatically.
Paste as picture
There are several alternatives to be able to pass a table from Excel to Word, making sure it is not altered and displayed the same, one of the easiest and most used ways is through an image. The first way you can use is to shade and choose the whole table, you can do it by pressing the left mouse button to choose the copy option or you can do it with the help of your keyboard, pressing ‘Ctrl + E’ to choose all the squares that the table has. When i do, go to word, At the top of the beginning you will see a box that says' Paste’ when you press it you will see some small options, select the one that says' Image’ or just hit 'Ctrl + V 'on the keyboard, now look at the table in Word as a picture.
The second way to do this is by heading to the start or your computer menu and type in the search engine 'Snipping Tool', this is an application that comes with all devices. When entering it you must press the option 'New', later cut your table. When you finish you will see that it will go to another tab of this one you can save it as an image. Now go to Word and go to the option 'Insert’ and later to ‘Image’, so that you can find the image you saved and attach it to the sheet. It should be mentioned that once added to Word you will not be able to make any type of modification in it.
How to link an Excel table to a Word document
In case of inserting the Excel table in Word format notice that it is not appreciated correctlyDo not worry, go to the gray shaded borders that are at the table boundaries. You will see that you can reduce or increase the size of the table without giving up 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 table from Excel to Word without modifying it and want to print it, it is recommended that you convert this file to PDF format; what's more you can print or send the document full without risking altering or modifying it.
Copy data from Excel to a Word document without a table
Excel y Word They are very important tools to be able to carry out our activities in the most correct way., but there are some functions that we do not know and that we should know. On the other hand, it may happen that you need to pass some information to Word to be able to modify it, but this usually happens in table format. There are two alternatives to pass only the content of the tables to Word.
Using the paste alternatives
Open Excel and copy all the information you want to pass, and later go to Word; hover the mouse over the sheet and press the right button, by doing so you will see how a menu will be displayed, go to section ‘Paste Options'And select the one that says’ Keep only text '. By doing this, you will see how all sorted data is found without tables.
Using the 'convert to text option’
To be able to do this, just repeat the first step, which is to copy the information from Excel and then paste it into Word. Once the table is selected, click on 'Design’ which will be found at the top. Then press the box ‘Convert to text‘, you will see a window appear and select the option you prefer to separate the text, finally click ok and you will see how the data range changes.
