How to Make a Spreadsheet in Word

By Kathryn Hatashita-Lee

Create a Microsoft Excel worksheet in a Word file to help you organize data and support your document. Microsoft Office 2010 provides tools from the Excel and Word command ribbons to formulate and edit your Excel worksheet data in one Word file. A click of the mouse enables you to switch between the range of tools in each program to customize your Excel and Word data for analysis.

Quick Access Toolbar

Open the Word 2010 program to display a blank document.

Click the arrow in the Quick Access Toolbar located in the top of the screen to open a list of options, and then click “More Commands” to open the Word Options dialog box.

Click the drop-down button under the “Choose commands from” to display a list, and then click “All Commands” to display an extensive list in the scrolling pane.

Scroll down the list, click the “Excel Spreadsheet” command to select, and then click the “Add” button to copy to the Customize Quick Access Toolbar pane.

Click the “OK” button to close the Word Options dialog box and to add this command button to the Quick Access Toolbar. The Excel Spreadsheet button will display the tiny Excel symbol in front of a blank worksheet.

Click in the Word document where you wish to insert the Excel worksheet.

Click the "Excel Spreadsheet" button to open an embedded blank table in the Word document.

Double-click in the table to convert to an Excel worksheet. The Word command ribbon converts to the Excel command ribbon.

Click the Excel commands to formulate or modify your data. Type your data in the worksheet.

Click outside the Excel worksheet to view as a table in this Word document. The Excel command ribbon will convert to a Word command ribbon.

Save this Word document by pressing the “Ctrl-S” keys on your keyboard to bring up the Save As dialog box. Type a file name and click on the preferred file type in the drop-list. Click the "Save" button to close the dialog box.

Insert an Excel Worksheet

Open the Word 2010 program to display a blank document.

Click the “Insert” tab on the command ribbon, click the “Table” button to open a list, and then click “Excel Spreadsheet” to insert a table in the Word document.

Click and drag the table to the preferred area in your Word document.

Double-click the table to convert to an Excel worksheet. The Word command ribbon will convert to an Excel command ribbon.

Type, formulate or modify the data in the worksheet using the Excel commands.

Click outside the worksheet to return to the Word command ribbon and work in the Word document.

Save this document.

Tips

To copy data from a saved Excel workbook and paste to a Word document, click and drag the cursor on the cells to select and highlight, and then press the “Ctrl-C” keys on your keyboard to copy. Click in the Word document, and then press the “Ctrl-V” keys to paste this data. The worksheet data displays as a table in Word.

×