How to Make a Spreadsheet in Word
Microsoft Word's Insert Table and Insert Object feature can facilitate the creation and addition of a spreadsheet into a Word document.
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
Place the cursor where you want to insert the table in your document.
Click the Insert tab, click Table in the Tables group and then select Insert Table to open the Insert Table dialog window.
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 information to display in the table.
To drag the table to a new position, hover your cursor over the table until the Table Move handle appears -- which resembles four arrows pointing in opposite directions inside of a box -- click the handle and then drag the table to the new position.
To add another row or column to the table, hover your cursor above or to the left of a row or column and then click the Insert Controls icon -- which resembles a plus sign inside of a circle -- to add a row or a column.
The Mini toolbar has the options to delete a column or row. Right-click a cell in the column or row you want to remove from the table to display the Mini toolbar. Select Delete and then select the appropriate option, such as Delete Rows.
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.
Select the Home tab and then click the Show/Hide button to display the formatting marks on your document, such as spaces and tabs.
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.
Press the Enter key to add a paragraph mark which indicates where you want a new row to start, and then select the text.
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.
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 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
Select the Insert tab, click Table and then select Excel Spreadsheet from the menu to insert a blank Excel spreadsheet into your document.
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.
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 when you have completed adding your information to set the spreadsheet in your document.
Double-click inside the spreadsheet to edit its contents.
Insert an Excel Spreadsheet
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.
Click the Create From File tab and click Browse. As an alternative, enter the location of the Excel file in the File Name field.
Browse to the Excel file's location, select the file and then click the Insert button.
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.
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.