How to Insert Excel Table into Word with Formulas (2 Easy Ways)

In Excel, we create tables for various purposes and we also need to insert this table into a word document. But if we just plain copy and paste the table into a Word file then we face difficulty as the table will paste as plain text/number. This means that all the formulas in the Excel sheet are not going to work in the pasted table in the Word document. In this article, how you can insert an Excel table with formulas into MS Word will discuss with adequate examples.


Download Practice Workbook

Download this practice workbook and word file below.


2 Easy Ways to Insert Excel Table into Word with Formulas

For the demonstration purpose, we are going to use the below dataset. The below dataset shows an Excel table that has already been inserted into MS Word with all the Excel formulas as shown in the Formula column. The dataset contains Components, Quantity, Unit Price, Total Price, and Formula as the column header.

insert excel table into word with formulas


1. Insert Excel Table as Object

This method will demonstrate how you can insert an Excel table in word directly as an object. MS Word has a built-in Excel environment. It enables users to insert Excel tables as an object and allows them to do most of the operations that can be done by MS Excel.

Steps

  • At first, you need to open Microsoft Word and go to the Insert tab. Then from the Tables group, click on Table. A dropdown menu will appear.
  • From the drop-down menu, click on Excel Spreadsheet.

Insert Excel table with formulas into word as object

  • Then you will notice that a new square box will spawn in the Word editor window.
  • And that box contains cells with a Column bar, Row bar, Gridlines, Formula bar, Leaf bar, and Name box just like an Excel worksheet.
  • In other words, a modified version of MS Excel is now open inside of the MS Word environment. This basically allows the user to create and modify Excel sheets, and tables inside the Word document.

  • Now you can easily add your desired table that contains formulas.
  • And you can also format the table the same way you do it in Excel.
  • One such example showing below. In this example, the formulas are actually in the Total Price column. The formulas for each row in the formula column in the range of cells F7:F17.
  • Now you can observe that you can add a table in word which contains Excel formulas.

Insert Excel table with formulas into word as object

Read More: How to Copy Excel Table to Word with Gridlines (2 Simple Methods)


2. Paste Special Feature to Insert Excel Table into Word with Formulas

This method demonstrates how a user can copy and paste an Excel table into a Word document with intact formulas using Paste Special command.


2.1 Utilizing Paste Command

This method will allow the user to modify the pasted table with keeping their parent source Excel file’s formulas intact.

Steps

  • In this method, we are going to copy a complete table from Excel and transfer it to MS Word.
  • For this, we need to select the table in the Excel worksheet and right-click on the mouse.
  • From the context menu, click on Copy.

  • Head to MS Word. Then from the Home tab, click on the Paste icon in the Clipboard group. A drop-down menu will appear.
  • From the drop-down menu, click on Paste Special.

  • A new window will appear. From that window, select Paste and click on Microsoft Excel Worksheet Object. Click OK after this.

  • After clicking OK, the table from the Excel worksheet is now pasted to the word document.

  • And this table has a Name box, Formula bar, Column bar, Row bar, Leaf bar, and status bar just like an Excel worksheet.

  • Also just like an Excel worksheet, it also preserves the formulas from the source Excel file. In this case, the formulas are in the range of cells E5:E15.
  • Formulas in each row are now shown in the Formula column.


2.2 Using Paste Link Command

This method will allow users to link their Parent Excel file to their Word file and make the changes that are done in the Excel file available instantly on the Word document.

Steps

  • In this method, we are going to copy a complete table from Excel and transfer it to MS Word.
  • For this, we need to select the table in the Excel worksheet and right-click on the mouse.
  • From the context menu, click on Copy.

Paste Link Command to insert excel table into word with formulas

  • Head to MS Word. Then from the Home tab, click on the Paste icon in the Clipboard group. A drop-down menu will appear.
  • From the drop-down menu, click on Paste Special.

  • A new window will appear. From that window, select the Paste link and click on Microsoft Excel Worksheet Object. Click OK after this.

  • After clicking OK, the table from the Excel worksheet is now pasted to the Word document.
  • You can see that the value of Quantity in the first row is 50. This doc file is connected with the source Excel file. This means that if we change the value of 50 in the source Excel file then it will change in the Word file concurrently.

  • In the Excel file, the value in cell C5 is 50, and the formula in cell E5 is
=D5*C5

This means that the value of cell E5 depends on cell C5.

  • This means if we change the value of cell C5, the value in E5 also changes.

Paste Link Command to insert excel table into word with formulas

  • Now, if both of those value changes also appear in the Word file, then we can conclude that our Word file and Excel file are now linked properly.
  • To demonstrate this, change the value of C5 from 50 to 100. Immediately you will notice the changes in the Total Price column value.

  • Head to the Word file and you will notice that the first row of both Quantity and Total Price values are now in Excel values.
  • From this, we concluded that we successfully inserted the Excel table into the Word document. Which is capable of changing cell value according to the changes made in the source Excel file.

Paste Link Command to insert excel table into word with formulas

In this way, you can insert an Excel table into Word with formulas quite easily.

Read More: How to Paste Excel Table into Word in Landscape (3 Easy Ways)


Conclusion

To sum it up, the question of how to insert an Excel table into word with formulas” is answered here in 2 different ways. We can directly insert a table in the word file as an object and work on that table as a normal Excel table. The other one is to paste special to preserve the original formula formatting. An extension of that method is to link with the parent Excel file. all of those methods.

For this problem, a workbook and doc file is available for download where you can practice these methods.

Feel free to ask any questions or feedback through the comment section. Any suggestion for the betterment of the Exceldemy community will be highly appreciable.


Related Articles

Rubayed Razib Suprov

Rubayed Razib Suprov

Hi, I am Rubayed Razib Suprov. Graduated from the Bangladesh University of Engineering Technology in Naval Architecture and Marine Engineering department. I joined Exceldemy on March 2022. I have a keen interest in both fluid dynamics and data analysis. I try to teach people what I learned so far about the Excel tool to date, and hope I can make some positive impacts.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo