Excel and Word are Microsoft applications, and thus they are compatible. Sometimes, you may need to add a similar table to Excel and Word. You do not have to create two separate tables on these two platforms. Excel allows the user to extract and use the Word table. However, one of the greatest downfalls of this operation is that there is no direct tool for converting Word Table to Excel. Therefore, new users may not be aware of the workarounds involved in converting a Word Table to Excel. This article will guide you on the typical steps and ways to convert Excel Table to Excel.
Using Copy and Paste Tool
The Copy and Paste Tool can be used to copy and paste content. In our case, the tool is of great use in converting a Word Table into an Excel Table. Let us discuss some of the steps the user needs to follow to achieve this:
1. Open the Word application and the document that contains the table you wish to copy.
2. Click on the Plus arrow icon on the top-left side of the table to select the entire day.
3. Go to the Home tab on the Ribbon, and locate the Clipboard section.
4. Under the clipboard section, click the Copy button. The selected table will be copied.
5. Open the Excel application and locate where you want to paste the table.
6. Go to the Home tab on the Ribbon, and locate the Clipboard section.
7. Under the clipboard section, click the Paste drop-down button. From the menu, click on the “Keep Source Formatting” icon.
That is all you need to do.
Using Keyboard Shortcuts
Keyboard shortcuts can ease converting a Word table to an Excel Table.
Steps:
1. Open the Word application and the document that contains the table you wish to copy.
2. Click on the Plus arrow icon on the top-left side of the table to select the entire day.
3. Press CTRL + C keys to copy the table.
4. Then, close the word application.
5. Open the Excel application and locate where you want to paste the table.
6. Press the CTRL + V keys to paste the table in the selected region. That is all you need to do.
Using Paste Special Tool
Steps to follow:
1. Open the Word application and the document that contains the table you wish to copy.
2. Click on the Plus arrow icon on the top-left side of the table to select the entire day.
3. Go to the Home tab on the Ribbon, and locate the Clipboard section.
4. Under the clipboard section, click the Copy button. The selected table will be copied.
5. Open the Excel application and locate where you want to paste the table.
6. Go to the Home tab on the Ribbon, and locate the Clipboard section.
7. Under the clipboard section, click the Paste drop-down button. From the menu, click on the Paste Special button.
8. In the Paste Special dialogue box, toggle on the Paste option and select the Microsoft Word Document Object option in the “As:” option. Finally, hit the OK button.