Press Shift + Space to select the entire row.
Press Ctrl + Shift + + (plus) to insert row.
Press F4 key multiple times will insert as many rows as you press.
Hold down Ctrl and click on the row number.
Press Ctrl + Shift + + (plus) to inserts a row at the specified row number.
The use of the name box is useful when selecting many rows at once.
Select the cell in the row you want to insert.
Enter the range of rows you want to select in the Name box.
When you have finished typing, press the Enter key.
Rows 4 through 14 have been selected.
Press Ctrl + Shift + + (plus) to insert multiple rows.
Please send us your comments on this article.