How to Add a Row in Google Sheets?

Open your Google Sheet

Select the row above or below where you want the new row

Right-click the row number

Click Insert 1 above or Insert 1 below

To add multiple rows, select multiple row numbers first

Right-click the selected rows

Click Insert X above or Insert X below

On mobile, tap the row number

Tap Insert row above or Insert row below

Use the Insert menu and choose Row above or Row below

Suggested for You

Trending Today