Insert multiple rows above or below a row in a Google Sheet

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.