Excel 2007: Add Rows & Columns to Spreadsheets

To add a row or column: Select any row or column, and then press the CTRL key at the same time as the PLUS SIGN (+) key on the numeric keypad.

To delete a row or column: Select the row or column, and then press the CTRL key at the same time as the MINUS SIGN (–) key on the numeric keypad.