Inserting an Excel Table

To insert an Excel table, we have two possibilities.
1. The table already exists in an Excel file.
2. There is absolutely no Excel file with a table.

Let me start with the first option. It is the quickest.  If the table already exists in an Excel spreadsheet, open the spreadsheet, select the table in Excel, click the “Copy” button.  Re-select the Word document where you want to place the table, and click the downward pointing arrow under “Paste”. In the drop-down menu select “Paste Special” and in the dialog box that appears, select “Microsoft Excel Worksheet Object”, and click the OK button.

This places the table in the Word document.
You can make changes which will automatically be adjusted to the cells with the help of formulas.

This is fast and easy.

The second option which is when our table does not exist as an Excel document is a little more tedious.
Select the “Insert” tab on the ribbon (1), click the “Table” (2) button, and select “Excel Spreadsheet” from the drop-down menu (3).

This places a blank Excel table in our Word document.

Next, select the table in the Word document, and click the “Copy” button on the ribbon.

Then, double-click the blank Excel table in your Word document.
Click the downward pointing arrow under “Paste”, and select the “Keep source formatting” option. Then, we do not have to do anything else.

This places the table copied from the Word document in the Excel file.

When the Excel file is deselected in the Word document, you can see that the table formatting is copied.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats