Insert an Excel Table

Enhance Word document with Excel table

  • Although Word tables allow  some simple calculations by clicking on Formula in the Data group on the Layout tab, the formula will not automatically re-calculate when one of the input numbers in the table has changed. This can easily lead to documents that have inaccurate data

  • Creating an Excel worksheet will help to keep the calculation accurate in the Word document

 

Insert an Excel table in Word document

  • Go to Insert tab > Tables group > click on Table > click Excel Spreadsheet

  • The plain Excel spreadsheet is inserted on the document with Excel tools displayed on the Ribbon

  • Adjust the size of the Excel spreadsheet by dragging it over

  • Go to Home tab > Clipboard group > click the Clipboard Dialog Box Launcher arrow

  • Select the Word table

  • Go to Home tab > Clipboard group > click Copy to copy the Word table to the Clipboard pane

  • Double-click on the Excel spreadsheet to active the spreadsheet

  • Go to Home tab > Clipboard group > click the Clipboard Dialog Box Launcher arrow

  • On the Clipboard pane, click the Word table > click the down arrow > select Paste to paste the Word table on the Clipboard pane into the spreadsheet

  • Adjust the column width to fix the content if needed

  • Apply appropriate formulas to perform calculations in the spreadsheet