1
Click the first row number
Click the number of the row where the new rows should go - here, row 3.
How to insert multiple rows in Google Sheets
Add several blank rows at once: select as many rows as you need, then insert them from the right-click menu.
Operations
2
Shift-click to select more rows
Hold Shift and click another row number. Select as many rows as you want to add - here, 2.
3
Right-click the selected rows
Right-click one of the selected row numbers.
4
Click Insert 2 rows above
Choose Insert 2 rows above (or below). The count matches the rows you selected.
5
Rows inserted
Two blank rows now sit where you selected, ready for new data.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.