How to Insert a Row in Excel 2007

By Necie Reed

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.

Things You'll Need

  • Microsoft Excel 2007

Step 1

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 2

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

Step 3

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

Step 4

Select the "Insert Sheet Rows" option.