In this blog post, I describe how to insert multiple rows, either above or below an existing row, in a Google Sheet. If you right click a row in a Google Sheet or press Insert then Rows , you will only be able to insert 1 row above or below the selected row: Resolution To insert more than 1 row above or below an existing row, whilst holding down the left mouse button (or using the SHIFT key), select the number of rows that you wish to insert, then either right click or press Insert then Rows .  Here, I have five rows selected, so I'm able to insert 5 rows above or below: The rows are inserted at the bottom of the selection if you insert below, or at the top of the selection if you insert above, as I've done here: Related Posts - You cannot delete a sheet with a linked form. Please unlink the form first.

This post describes how to fix the error: There was a problem You cannot delete a sheet with a linked form. Please unlink the form first. Cause This can occur if you have created a new form which is automatically linked to the sheet. I did this accidentally when I was trying to go to Data -> Sort Sheet. Resolution To resolve the issue, go to Tools -> Manage form -> Unlink form: You should now be able to successfully delete the form: Related Posts -  Insert multiple rows above or below in a Google Sheet