Excel > Options > Proofing
Click the "AutoCorrect Options" button
In the dialog box that pops up, select the second tab, "AutoFormat As You Type"
Make sure the box for "Include New Rows and Columns in Table" is checked

Susan's table method worked fine for me (XP/Excel 2010)