How to Make a Spreadsheet in Word

Although Microsoft Word is a word processing program, it is possible to add a spreadsheet to a Word document using the program’s Insert Table feature. Create a spreadsheet using a table or by adding a blank Excel spreadsheet directly to your document. In addition, use the Insert Object feature to insert an already completed Excel spreadsheet into Word.

Create a Table

Step

Place the cursor where you want to insert the table in your document.

Position your cursor at the insertion point.
credit: Image courtesy of Microsoft
Open the Insert Table dialog window.
credit: Image courtesy of Microsoft

Step

Click the Insert tab, click Table in the Tables group and then select Insert Table to open the Insert Table dialog window.

Choose the number of rows and columns for the table.
credit: Image courtesy of Microsoft

Step

Enter the number of columns and rows you want the table to have in the Table Size section and then click OK to insert the table into your document.

Enter the table's data.
credit: Image courtesy of Microsoft

Step

Enter the information to display in the table.

Create a Table Using Text

Instead of manually adding your text to a table, use the Convert Text to Table feature to automatically convert your document's existing text to a table.

Step

Select the Home tab and then click the Show/Hide button to display the formatting marks on your document, such as spaces and tabs.

Display your document's formatting marks.
credit: Image courtesy of Microsoft
Insert special characters into your text.
credit: Image courtesy of Microsoft

Step

Insert a character that indicates where you want the text to divide into columns. For example, position your cursor at the location in your text where you want a column to start, and then press the Tab key to place an arrow icon in your text as an indicator.

Step

Press the Enter key to add a paragraph mark which indicates where you want a new row to start, and then select the text.

Open the Convert to Text dialog box.
credit: Image courtesy of Microsoft

Step

Click the Insert tab, select Table in the Tables group and then choose Convert Text to Table to open the Convert Text to Table dialog box.

Select the special character that you used to divide the columns.
credit: Image courtesy of Microsoft

Step

Review the number in the Number of Columns box to ensure it is identical to the number of columns you want your table to have. Select the radio button in the Separate Text At section that matches the separator character you used to divide the columns, such as Tabs. Click the OK button to convert the text.

Review the completed table.
credit: Image courtesy of Microsoft

Step

Review the text in the table for accuracy. If necessary, hover your cursor over the table and drag the Table Move handle to move the table to a new position.

Create an Excel Spreadsheet

Step

Select the Insert tab, click Table and then select Excel Spreadsheet from the menu to insert a blank Excel spreadsheet into your document.

Insert a new Excel spreadsheet through the Excel Spreadsheet feature.
credit: Image courtesy of Microsoft
Enter the spreadsheet's data.
credit: Image courtesy of Microsoft

Step

Add your data and edit the spreadsheet similarly to a regular Excel spreadsheet in the Excel program. For example, to add a new worksheet, click the Plus icon at the bottom of the spreadsheet.

Use the spreadsheet's handles to change the number of rows and columns.
credit: Image courtesy of Microsoft

Step

Click the handles at either corner or middle of the spreadsheet and drag them to change the number of rows and columns.

Click outside the spreadsheet after adding the data.
credit: Image courtesy of Microsoft

Step

Click outside the spreadsheet when you have completed adding your information to set the spreadsheet in your document.

Insert an Excel Spreadsheet

Step

Click the Insert tab, click Object in the Text group and then select Object from the drop-down menu to open the Object dialog window.

Open the Object dialog window by selecting Object from the Object menu.
credit: Image courtesy of Microsoft
Click Browse to open the Browse window.
credit: Image courtesy of Microsoft

Step

Click the Create From File tab and click Browse. As an alternative, enter the location of the Excel file in the File Name field.

Select the Excel file to embed.
credit: Image courtesy of Microsoft

Step

Browse to the Excel file's location, select the file and then click the Insert button.

Embed the spreadsheet by clicking the OK button.
credit: Image courtesy of Microsoft

Step

Select the Link to File check box to insert the Excel spreadsheet into your Word document and also create a shortcut to the original Excel file. Any change you make to the original Excel file is automatically updated in the embedded spreadsheet.

Step

Choose the Display as Icon option to insert an icon representing the Excel spreadsheet. Double-clicking the icon opens the Excel spreadsheet in the Excel program. Click the OK button to insert the spreadsheet.