When inserting new rows into an existing spreadsheet, you can insert only one row at a time.

Name: When inserting new rows into an existing spreadsheet, you can insert only one row at a time.
Brand: Quizplus
Rating: 4.8 (25 reviews)

Question

Quizplus · Accepted Answer

You can actually insert multiple rows at once by selecting the desired number of rows and right-clicking on the selection, then choosing "Insert" from the menu. Alternatively, you can use the "Insert" button in the ribbon and select "Insert Sheet Rows".

When Inserting New Rows into an Existing Spreadsheet, You Can