If you ask any user about which program is best used to build tables, then he will answer that "Excel." And that is exactly so. But no one will argue that in another office program - in Word - sometimes you also need to create tables. Fortunately, it is possible to move this element from one program to another.
This article will discuss how to transfer a spreadsheet from Excel to Word. Three most popular methods of this operation will be analyzed. All of them are sufficiently different from each other, so it is recommended that you read the article to the end in order to determine for yourself which method is best used.
Moving a table from Excel to Word
Before proceeding to a detailed analysis of all three methods, how to transfer a spreadsheet from Excel to Word, let's briefly go over their essence. Three methods will be presented below:
- regular copying;
- copying using a special paste;
- Paste from a document.
The first method will allow you to quickly move the table from Excel to Word. However, for this it is necessary to open each program individually. There are also more significant disadvantages, which we will discuss directly in the analysis of the method itself.
The second method also involves two programs, but with it you can link the Excel spreadsheet to the Vorda table. How this, and why it is needed, will be considered in the analysis itself.
The third method, on the contrary, allows you to work only in Word and insert a table from Excel from it without opening the table editor itself. But it has both advantages and disadvantages.
Now we will begin to analyze how to transfer a spreadsheet from Excel to Word, and you will find out which one is best for you.
The first method: regular copying
So, first of all, we’ll analyze the easiest way to transfer a spreadsheet from Excel to Word:
- First of all, you need to open the Word document into which you want to insert the table, as well as the Excel program with the same table.
- Now in Excel, select the fragment that you want to move to Word.
- It must be copied. There are three ways to do this. The first is to click the right mouse button (RMB) on the selected area and select the "Copy" item in the context menu. The second is to click the corresponding icon on the toolbar, which is located in the "Clipboard" area. You can see his exact location in the image below. The third method is the simplest - you need to press CTRL + C.
- After the item is copied, go to the Word document. First, left-click (LMB) in the place where you want to insert the table.
- Now it must be directly inserted. There are three ways to do this. Open the context menu by pressing RMB and select "Save Original Formatting" in the menu. Click the corresponding icon on the toolbar. You can also see its location in the image below. The third involves the use of hot keys, only this time CTRL + V.
As a result, the table will be inserted. This was the first way to transfer a table from Excel to Word 2007. By the way, this instruction will be suitable for other versions of the program, albeit with some changes.
The second way: copying using a special paste
Now we will discuss how to transfer a table from Excel to Word 2010. It is also worth noting that this method is suitable for other versions of the program:
- So, again you need to open two documents - Excel and Word. In Excel, select the desired area and place it on the clipboard, using one of the methods described above.
- After that, go to the Word program. You need to open the pop-up menu of the Insert tool. To do this, click on the arrow below it.
- In the menu, select "Paste Special ..." - the window of the same name will open. In it, you need to switch to the "Link" item and in the "How" field select "Microsoft Excel worksheet (object)".
- After the done actions click "OK" - the table will be inserted into the document.
You may notice that the table is inserted in the form of a picture - this means that you cannot edit it by making any changes. Of course, this applies to the disadvantages of this method. However, there are pluses - the table will automatically shrink, taking a size that fits perfectly into your document.
Third way: pasting from a document
Using the third method, you can generally transfer a table from Excel to Word without using the Excel program itself. This is done very simply:
- In the Word program, you need to go to the Insert tab.
- In it, click on the "Object" icon, which is located in the "Text" area.
- In the window that opens, go to the "Create from file" tab. There, click the "Browse" button and in the explorer that opens, select the Excel file.
- As a result, it remains only to click on the "OK" button, and the table will be inserted.
This method has only one drawback, in addition to inserting a table in the form of a picture, it will be inserted in its entirety, that is, you will not be able to select the area you need.
Conclusion
As a result, there are three ways to insert a table from Excel into Word. All of them are good in their own way and each has its own shortcomings and advantages. But how to use it is up to you to decide.