Inserting Rows in a Worksheet

If you want to insert rows in an Excel worksheet, you probably know that you can do so by displaying the Home tab of the Ribbon and clicking Insert in the Cells group. 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 Ribbon, 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 click Insert in the Cells group on the Home tab of the Ribbon. Excel dutifully inserts five rows in your worksheet, just before the first row you selected.