Insert multiple rows
You can add multiple rows to a spreadsheet simultaneously.
Procedure. Procedure
Open a spreadsheet.
Click the row above which you want to insert rows.
Click the down arrow next to
Insert cells.Click
Insert cells. The dialog opens.Enter the number of rows and click OK.
The new rows are inserted above the marked row.