How to Enable Extra Rows in Excel 2007

1. Select the row above which you want to place the new row. You can do this by left- or right-clicking the row number on the left-hand side. For example, if you want to insert a single row between rows three and four, select row four. If you want to insert three rows between rows three and four, select rows four, five and six by clicking on row four, holding down the left mouse button and dragging the cursor down over rows five and six to highlight them as well. To select rows that are not adjacent to each other hold down the 'Ctrl' key and click on the rows you wish to highlight.
2. Click the 'Insert' option at the top of the screen. Navigate down to 'Rows' and click the left mouse button. If done correctly, the new row or rows will appear above the row you've selected. In the case of multiple or non-adjacent rows, they will all appear at once. Alternately, you can right-click the row below where you want to insert a new one. Choose 'Insert' from the box that pops up and select 'Rows.' This will perform the same function.
3. Hold 'Ctrl' and press 'Y' on your keyboard to repeat the row insert. The insertion operation that is repeated will be the same one you just performed. This means if you inserted three rows, then you hold down 'Ctrl' and press 'Y,' three new rows will be inserted.