Try the Word Course for Free!

Insert an Excel Worksheet into a Word Document – Tutorial

/ / Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365, Word 2013, Word 2016
Insert an Excel Worksheet into a Word Document – Tutorial: A picture of a user inserting an Excel spreadsheet into a Word document.

Insert an Excel Worksheet into a Word Document: Overview

            You can easily insert an Excel worksheet into a Word document to harness the power of Excel within Word. This helps Word users who like creating worksheets and performing calculations in Microsoft Excel. To insert an Excel worksheet into a Word document, you must have both Microsoft Word and Microsoft Excel installed on your computer as part of the same Microsoft Office installation. After you insert an Excel worksheet into a Word document, you can then edit the information in the worksheet using the Excel interface. However, it displays the data in the Word document as if it is a table.

            To insert an Excel worksheet into a Word document, place the insertion marker into the document location where you want to show the worksheet data. Then click the “Table” button within the “Tables” button group on the “Insert” tab within the Ribbon. Then click the “Excel Spreadsheet” command in the button’s drop-down menu. Doing this then inserts an Excel worksheet object into that location in the document.

Insert an Excel Worksheet into a Word Document – Tutorial: A picture of a user inserting an Excel spreadsheet into a Word document.

Insert an Excel Worksheet into a Word Document – Tutorial: A picture of a user inserting an Excel spreadsheet into a Word document.

            At that point, you are working within the Excel interface. Edit the contents of the cells in the Excel worksheet area. Also, apply all formatting to the cells in Excel, as you cannot make any formatting changes in Word.

            Note that the embedded Excel worksheet object has a dashed border around it. Only the information shown in this area appears in the document. To resize this display area to increase the data shown or remove extra cells from appearing, place your mouse pointer over the small black resizing squares that appear around the perimeter of the embedded worksheet object until your mouse pointer turns into a double-pointed arrow. Then click and drag to increase or decrease the size of the worksheet area that appears in the document.

            After entering the worksheet data and resizing its display, then click into the document area. Doing this then changes the display of the worksheet to a table. To edit its contents again in the future or to change its display size, you must return to editing mode. To return to editing mode, double-click the embedded Excel worksheet object in the document. It then switches back to Excel so you can make the necessary changes. Then click back into the document after editing it to change it back into an embedded table within Word.

            To delete an embedded Excel worksheet object in your document, simply click it to select it. Then press the “Delete” or “Del” key on your keyboard to delete the Excel worksheet.

Insert an Excel Worksheet into a Word Document: Instructions

  1. To insert an Excel worksheet into a Word document, place the insertion marker into the document location where you want to show the worksheet data.
  2. Then click the “Table” button within the “Tables” button group on the “Insert” tab within the Ribbon.
  3. Then click the “Excel Spreadsheet” command in the button’s drop-down menu.
  4. Enter the information to display into the Excel worksheet area.
  5. Also, apply all formatting to the cells in Excel, as you cannot make any formatting changes in Word.
  6. To resize the display area, place your mouse pointer over the small black resizing squares that appear around the perimeter of the embedded worksheet object until your mouse pointer turns into a double-pointed arrow.
  7. Then click and drag to increase or decrease the size of the worksheet area that appears in the document.
  8. To change the display of the worksheet to a table when finished, click into the document area.
  9. To edit its contents or size in the future, you must return to editing mode.
  10. You can do this by double-clicking the embedded Excel worksheet object in the document to switch back to Excel.
  11. Then make the necessary changes.
  12. To change it back into an embedded table in Word when finished, click back into the document.
  13. To delete an embedded Excel worksheet object in your document, click it to select it.
  14. Then press the “Delete” or “Del” key on your keyboard to delete the Excel worksheet.

Insert an Excel Worksheet into a Word Document: Video Lesson

            The following video lesson, titled “Inserting a Microsoft Excel Worksheet,” shows you how to insert an Excel worksheet into a Word document. This video lesson is from our complete Word training, titled “Mastering Word Made Easy v.2016-2013.”

TOP
Extra 30% Off Store-Wide 0 Days 12 Hours 11 Minutes 48 Seconds      Use Coupon: EXTRA30
Shop Now