How to Create a Spreadsheet in Word

By Tricia Goss

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.

Things You'll Need

  • Microsoft Word 2003, 2007 or 2010

Step 1

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 2

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 3

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 4

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 5

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."