In this article we will show you how to use the insert row shortcut in Google Sheets for both Windows and Mac in just a few simple steps.
Open the exact sheet where you want to insert rows. For our example we added dummy data so you can see the rows added in the process.
If you want to add a single row, select the row that is below where you want to insert one. If you want to add multiple rows, select the same number of rows as you want to add.
The shortcut inserts the same number of rows as the selected ones above them.
Result:
Open the exact sheet where you want to insert rows. For our example we added dummy data so you can see the rows added in the process.
If you want to add a single row, select the row that is below where you want to insert it. If you want to add multiple rows, select the same number of rows as you want to add.
The shortcut inserts the same number of rows as the selected rows above.
Result:
You can insert rows below the selected rows using the steps below:
If you want to add a single row, select the row that is below where you want to insert one. If you want to add multiple rows, select the same number of rows as the rows you want to add.
A dropdown list will appear.
The row is inserted below the selected cell.
We hope this article has helped you and given you a better understanding of the shortcut to insert rows in Google Sheets. You might also like our articles on how to insert a row and how to change row height in Google Sheets. On a side note, we also recommend reading our guide on how to automatically send emails from Google Sheets.
