inserting multiple rows in excel

Inserting Rows
Summary: Inserting a single row is easy when you use the Insert menu. When you need to insert multiple rows, then you can use the simple techniques described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
If you want to insert rows in a worksheet, you probably know that you can do so by choosing Rows from the Insert menu. This works marvelously for inserting single rows.

If you want to insert multiple rows, you have two choices. First, you can insert a single row by using the menu, as already mentioned. Then you simply press F4 repeat the command and keep inserting rows.

The second method involves selecting rows before inserting. For instance, if you want to insert five rows, select five existing rows in the worksheet, then choose Rows from the Insert menu. Excel dutifully inserts five rows in your worksheet, just before the first row you selected.