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)
Keep Up with TechRepublic