How to transfer a table from Excel to Word. 3 ways to transfer a table from Excel to Word

Excel is a multifunctional program that allows you to perform various manipulations with tabular information. In the word processor Word, you can also implement the creation of tables, but it is more designed for working with texts. Often, users need to make sure that the table developed in Excel is correctly transferred to Word. From this article, you will get acquainted with all the possible methods for implementing this procedure.

Standard copy and paste label

This option is considered one of the easiest to use. It involves the usual copying of the tablet, and then pasting it into another program.

Algorithm of actions that implements the transfer of the table

Detailed instructions look like this:

1. Initially, we open an Excel file with the necessary table.
2. Using the left mouse button pressed, we select the plate (or its fragment). We select only the information that we want to move to the Word word processor.

3. Right-click anywhere in the selected table. In the context menu that appears, click on the “Copy” item. An alternative option is to use the keyboard shortcut “Ctrl + C” on the keyboard.

4. We have copied the necessary information to the clipboard. At the next stage, we open the Word text editor.
5. We open the document we need or create a new one, into which we will eventually transfer the copied plate.

6. We click RMB anywhere in the open text document. In the context menu that appears, left-click on the element called “Insert”. An alternative option is to use the keyboard shortcut “Ctrl + V” on the keyboard.

7. Ready! We have implemented the insertion of a tablet from the Excel program into the word processor Word. We look at the lower right corner of the added table.

8. When you click on the icon, which has the shape of a folder with a leaf, we will open a list with insertion variations. In this example, you choose the original formatting. It is worth noting that thanks to this function, you can insert information in the form of a picture, text, or apply the style of the last plate.

Important! This method has a huge disadvantage. The width of the workspace in Word has restrictions, but in Excel there are no restrictions. For correct insertion, it is necessary to ensure that the plate has suitable width dimensions. Otherwise, the fragments of the table will not fit on the workspace and will crawl out of the sheet of the word processor.

In any case, this method has a huge advantage – fast execution and ease of use.

Paste special that implements table wrapping

Detailed instructions look like this:

1. We open a spreadsheet document and copy a tablet from it or its fragment to the clipboard, as in the previous method.

2. We move to the Word word processor and hover over the location of the plate insertion.

3. Next, press RMB. A small context menu appeared on the display. We find the element with the name “Paste Special …”, and click on it with the left mouse button.

4. As a result of the actions performed, a window called “Paste Special” appeared. We put a fad near the word “Insert”, and in the lower list of the “As:” field, click on the element “Microsoft Excel Sheet (object)”. Click the left mouse button on “OK” to confirm the changes.

5. As a result of the actions performed, the tablet took the format of a picture and was displayed in the Word word processor.

It is worth noting! If the plate does not completely fit on the workspace, then its size can be easily edited by simply moving its borders. It became possible to move the borders due to the fact that the plate has a picture format.

6. In addition, if you double-click on the plate, it will open in the spreadsheet format to make changes. After making all the changes and closing the table view, all adjustments will be displayed in the word processor.

Inserting a table from a file into Word

In the previously considered 2 methods, it was initially necessary to open and copy the plate from the spreadsheet editor. In this method, such manipulations are not necessary. We start by opening Word. Detailed instructions look like this:

1. We move to the “Insert” section, located in the main menu of the program. We find the block of commands “Text” and open its list. In the list that appears, find the element “Object” and click the left mouse button.

2. In the window that appears, which has the name “Object”, left-click on the button “From file …”, located in the lower left part of the window. Then we select the file that contains the information plate we need. At the end of our actions, click LMB on the “Insert” element.

3. The tablet, as in the 2nd method considered earlier, has moved to the Word word processor in the format of a picture. Its value can be easily edited by simply moving the borders of the plate. If you double-click on the plate, it will open in the spreadsheet format for making changes. After making all the changes to the table and closing the table view, all adjustments will be displayed in the word processor.

4. It should be noted that as a result, the entire content of the selected document is transferred, so before transferring the file, it must be cleared of unnecessary information.

Conclusion

From the article, we found out several ways to transfer a tablet from Excel to Word. The displayed result of the inserted label depends entirely on the selected transfer method. Each user will be able to choose for himself the most convenient way to carry out this procedure.