Insert a row

1. Select a cell on the row and go to the Home tab.

2. Select the down arrow under   Insert in the Cells group.

3. Select   Insert Sheet Rows. 
   The row is inserted right above the cell your cursor is on.

Tip: You can also select the next row under where to insert, and press Alt+I+R or right-click a cell and select Insert, choose Entire Row and then OK.

1. Select any cell within the row.

2. Go to Home and select   Insert.
   If you don't see Insert, select the ellipsis and choose  Insert.

3. Select  Insert Rows Above.
   The row is inserted right above the cell where your cursor is.

Tip: You can also right-click a cell and select Insert and choose Table Row Above.

1. Select any cell within the row.

2. Go to Home and select   Insert.

3. Select  Insert Sheet Rows.
   The row is inserted right above the cell where your cursor is.

Tip: You can also control-click a cell and select Insert, choose Entire Row and then OK.