MS Excel and MS Word are the two most prominent global software. MS Excel is widely used to measure, analyze and visualize data. On the other hand, MS Word is the predominant software to prepare reports, documents, and so on. Often we need to prepare a table containing formulas in the Excel file and insert them into the Word file for many purposes. But inserting a table with formulas into the Word file is not everyone’s cup of tea. Further, it may require linking the Table of Word file with Excel Table sometimes, so that it will update automatically if any changes take place. In this article, we will learn to insert the Excel table into a Word file containing formulas with adequate examples.
📁 Download Excel File
To practice please download the Excel file from here:
Learn to Insert Excel Table into Word with Formulas with These 3 Methods
We are going to construe 3 quick examples to insert an Excel Table containing formulas into an MS Word file. Here we consider a dataset named Weekly Sales Data of Amigo Super Store containing Seller, Cost Price, Selling Price, and Net Income. The dataset has 5 columns as well as 10 rows. To construct the methods, we will discuss the use of the Paste Special Option and Excel Spreadsheet option from the MS Word file. So, let’s get started.
1. Insert an Excel Spreadsheet with Formulas into Word
Nowadays MS Word allows you to work with Excel Spreadsheets to calculate data or plot graphs and so on. But you must use MS Word 2016 or higher versions to enjoy this inevitable feature. Inserting the table with an Excel Spreadsheet option will be your cup of tea, once you get the steps from our article. Please check out the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- First, open an MS Word file.
- Secondly, go to the Insert menu of Top Ribbon and expand the Table feature by clicking the drop-down icon.
- Thirdly, choose Excel Spreadsheet from the Table list.
- Thus, a worksheet will be displayed in the word book.
- Then select the data from the Excel Worksheet and press Ctrl+C to copy them.
- Afterward, press Ctrl+V to press the data into the Excel Spreadsheet of MS word.
- Therefore, after pasting the data into MS Word Spreadsheet, it takes place like the following picture.
- Finally, once we are done with the spreadsheet, it looks like a simple table. Moreover, all the spreadsheet layout format, rows, columns numbers as well as status bar get vanished.
2. Insert Excel Table into Word with Formulas
Without any hesitation, one can use the Paste Special option to insert the table into an MS Word book. Before that one must enable the Show Formula feature in the Excel file to show the formulas referring cells. Please follow the necessary steps to paste the table into a Word file.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, open the Excel Worksheet containing data.
- Then, selecting the dataset, press Ctrl+C to copy the data set.
- Next, Open the MS Word file.
- After that, expand the Paste options from the Home tab.
- Further, select the Paste Special option from the Paste feature.
- From the Paste Special option, we can insert a table with two approaches.
2.1 Use Microsoft Excel Worksheet Object Option to Insert Table with Formulas
One can insert a table containing formulas as the Microsoft Excel Worksheet Object option from the Paste option. Please check out the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- First, from the Paste Special box, select the Paste option. However, the selection of the Paste option will only insert the table into the Word file.
- Further, select As Microsoft Excel Worksheet Object and hit the OK button.
- Therefore, the Table containing data including formulas inserted under Net Income heading in the Word file.
2.2 Formatted Text Option to Insert Excel Table into Word with Formatting
To export the formatted texts from the Excel Table, MS Excel allows the Formatted Text option from the Paste Special feature. Please follow the required steps.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, select from the Paste Special box, select the Paste option. Perhaps, the Paste option inserts the table into a Word file and doesn’t change with respect to the Excel file.
- Next, choose the Formatted Text option and hit the OK button.
- Therefore, formatted texts and table layouts are inserted into a word file.
3. Importing Data from Excel to Link MS Word and Update Formulas Automatically
Linking to MS Worksheet, inserting a table into an MS Word file is also possible from the Paste Special feature. If data changes in the Excel worksheet, data will also change automatically in the MS Word book. Please follow the necessary steps to link with the Excel Worksheet and insert the table into a Word file.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, selecting the dataset, press Ctrl+C to copy the dataset.
- Secondly, open the MS Word file.
- Thirdly, Expand the Drop-down list of the Paste option from the Home tab and select Paste Special option.
- Thus a Paste Special box appears.
- Next, select Paste Link and Microsoft Excel Worksheet Object options from the options.
- Finally, hit the OK button.
- Therefore, a table is imported in the MS Word file linking with the MS Excel file.
- Now changing the formulas into E6:E10 cells, we observe the changes in the table of the MS Word file.
📄 Important Notes
🖊️ Remember, Excel Spreadsheet is available on MS Word 2016 or higher version.
🖊️ Linking the Table of Excel sheet with the Table of MS Word, data changes automatically.
🖊️ To show the formula, navigate the Formula menu from Top Ribbon and select the Show Formula feature.
🖊️ When the Show Formula feature is enabled, Middle Alignment will not occur.
📝 Takeaways from This Article
📌 Excel Spreadsheet option to insert a table in MS Word.
📌 Excel Worksheet Object tool to export the Table from MS Excel with or without the linking option.
📌 Formatted Excel Table from MS Excel into MS Word.
In this article, we expound on 3 easy methods to insert a Table from Excel into Word with formulas. I hope you enjoyed your learning and will be able to export tables from Excel with linking as well as formatting. Any suggestions, as well as queries, are appreciated. Don’t hesitate to leave your thoughts in the comment section. For better understanding and new knowledge, don’t forget to visit www.ExcelDen.com.