How to Add a Row in Google Sheets: Every Method Explained

Google Sheets makes it straightforward to insert rows — but the fastest method depends on where you're working, how many rows you need, and whether you're on desktop or mobile. Here's a complete breakdown of every reliable way to do it.

The Basics: What "Adding a Row" Actually Means

In Google Sheets, adding a row can mean two different things:

• Inserting a row between existing rows (pushing content down)
• Appending a row at the bottom of your data (extending the sheet)

Both are common, and Google Sheets handles each slightly differently. Getting familiar with the distinction saves time when your spreadsheet already has data you don't want to overwrite.

How to Insert a Row on Desktop (Web Browser)

This is the most common scenario — working in Chrome, Firefox, Safari, or Edge on a laptop or desktop.

Method 1: Right-Click Context Menu

1. Click the row number on the left side of the sheet (e.g., click "5" to select the entire fifth row)
2. Right-click to open the context menu
3. Choose "Insert 1 row above" or "Insert 1 row below"

This is the fastest point-and-click method. Selecting multiple row numbers before right-clicking lets you insert the same number of rows at once — select three rows, and you'll see the option to insert three rows above or below.

Method 2: The Insert Menu

1. Click a row number or any cell in the row where you want to insert
2. Go to the top menu: Insert → Rows → Insert row above or Insert row below

This method works the same way but is useful if you're already navigating the menu bar.

Method 3: Keyboard Shortcut

Google Sheets doesn't have a single-key shortcut for inserting rows by default, but you can use this combination:

• Select a row by clicking its row number
• Press Alt + I (Windows/Linux) or Ctrl + Option + I (Mac) to open the Insert menu
• Then press R for rows

Alternatively, after selecting a row, press Ctrl + Shift + + (Windows/Linux) or Cmd + Shift + + (Mac) to insert a row directly above the selected one. ⌨️

Method 4: Insert Multiple Rows at Once

To add several rows in one action:

1. Click and drag across multiple row numbers (or click one, hold Shift, click another)
2. Right-click and choose "Insert X rows above" — the number matches however many rows you selected

This beats inserting rows one at a time when you're restructuring a large dataset.

How to Add a Row on Google Sheets Mobile (Android & iOS)

The mobile app works differently from the desktop version — touch controls replace right-click menus.

On Android

1. Tap a row number to select the entire row
2. A toolbar appears at the top — tap the three-dot menu (⋮) or look for the Insert option
3. Choose "Insert row above" or "Insert row below"

On iOS (iPhone/iPad)

1. Tap the row number to highlight the row
2. Tap again to bring up the context menu
3. Select "Insert row"

Mobile functionality is more limited than desktop — you can't insert multiple rows simultaneously as easily, and the interface varies slightly depending on your app version.

Adding a Row at the Bottom of Your Sheet

If your spreadsheet has a defined data range and you want to extend it downward:

• Scroll to the last row and simply type in the next empty row — no insertion needed
• Alternatively, right-click the last row number and select "Insert 1 row below"

Google Sheets automatically expands to accommodate new data. By default, new sheets have 1,000 rows, but you can add more by scrolling to the very bottom and clicking "Add X more rows at bottom" — a prompt Google Sheets displays natively.

Using Keyboard Navigation for Faster Row Insertion

Power users often prefer staying on the keyboard entirely:

Combining Shift + Space to select a row and then Ctrl + Shift + + to insert is one of the quickest workflows once it becomes muscle memory.

Adding Rows Programmatically with Google Apps Script

For users managing large sheets or automating data entry, Google Apps Script (Sheets' built-in scripting environment) lets you insert rows with code: