How to Insert a Row in Excel 2007

Even after thoroughly planning and designing your spreadsheet, you may find that you need to insert new rows into it. Adding new rows allows you to add data entries directly into the spreadsheet without deleting or altering other data within the document. Fortunately, inserting new rows is easy in Excel 2007.

...

Step

Click on any cell in the row below the location where you would like to insert a new row. For example, if you'd like to add a row above row 11, click on a cell in row 11.

Step

Locate the "Cells" group on the Microsoft Excel "Home" tab. It is located at the upper-right-hand corner of the screen.

Step

Click on the "Insert" drop-down button located in the Cells group (the first button displayed).

Step

Select the "Insert Sheet Rows" option.