Insert Row

 

The Insert_Row menu function inserts a row into the active worksheet of the current workbook. The existing row and all rows below it at that point are shifted down to make room for the new row.

 

You can also shift blocks of data around in a worksheet by dragging selected blocks with the mouse; hold down the left mouse key with the mouse cursor on the edge of a selected block to do this.