Google Sheets Insert Row Shortcut - For Windows and Mac

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.

‍

‍

Insert Row Shortcut Google Sheets (Mac)

‍

1. Open the sheet

‍

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. 

2. Select the row or rows below where you want to insert rows

‍

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. 

3. Use shortcut ⌘ + Option + =

The shortcut inserts the same number of rows as the selected ones above them. 

‍

Result:

‍

Insert Row Shortcut Google Sheets (Windows)

1. Open the sheet

‍

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. 

2. Select the row or rows below where you want to insert rows

‍

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. 

3. Use the shortcut Ctrl + Alt + =

‍

The shortcut inserts the same number of rows as the selected rows above. 

‍

Result:

FAQs

‍

How can I insert rows below the selected rows?

‍

You can insert rows below the selected rows using the steps below:

1. Select the number of rows above where you want to insert them

‍

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. 

‍

‍

2. Use the shortcut Alt+Shift+i then r for Windows and Ctrl+Option+i then r for Mac

‍

A dropdown list will appear.

‍

3. Press b.

‍

The row is inserted below the selected cell.