-
Select any cell within the row.
-
Go to Home and select Insert.
If you don't see Insert, select the ellipsis (...) and choose Insert. -
Select Insert Sheet Rows.
The row is inserted right above the cell where your cursor is.
Tip: You can also right-click a cell and select Insert, choose Sheet Rows and then OK.
-
Select any cell within the row.
-
Go to Home and select Insert.
-
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.