How to Create a Spreadsheet in Word

A spreadsheet is a paper or electronic page with gridlines that allow you to display, organize and categorize information neatly into rows and columns. While Excel is the Microsoft Office spreadsheet application, you may not have access to it or simply prefer to work in Word. You can create a spreadsheet in Word by inserting a table with the number of rows and columns you require. You can even sort the spreadsheet once you have entered data into it.

...
Make a spreadsheet in Word.

Step

Start Microsoft Word and open a new, blank document. Change the page orientation from "Portrait" to "Landscape." In Word 2003, go to the "File" menu, select "Page Setup," go to the "Margins" tab and select "Landscape." In Word 2007 or 2010, go to the "Page Layout" tab, click on "Orientation" and select "Landscape."

Step

Go to the "Table" menu in Word 2003, point to "Insert" and select "Table." Go to the "Insert" tab in Word 2007 or 2010, click "Table" and select "Insert Table." Enter the number of rows and columns you want the spreadsheet to have. Click "AutoFit to Window" and click "OK."

Step

Change the page margins to center your spreadsheet and help it better fit the page. Go to the "File" menu in Word 2003, select "Page Setup" and go to the "Margins" tab. Go to the "Page Layout" tab in Word 2007 or 2010, click "Margins" and then click "Custom Margins." Change the margin sizes and click "OK."

Step

Enter data into the table cells. To format row or column headings, select the row or column you wish to format. Click "Bold" on the "Formatting" toolbar in Word 2003 or the "Home" tab in Word 2007 or 2010 to make the fonts bold. You can change the font size there, as well. To center the text in the selected row or column, press the "Center" alignment button on the "Formatting" toolbar in Word 2003 or the "Home" tab in Word 2007 or 2010, or use the keyboard shortcut "Ctrl+E."

Step

Sort the data once you have entered it into the spreadsheet. Go to the "Table" menu and select "Sort" in Word 2003. Go to the "Table Tools Layout" tab in Word 2007 or 2010 and click "Sort." Select the column or columns by which you wish to sort. Select "Ascending" or "Descending." Click "OK."