How to Insert a Row in Google Sheets

When building a spreadsheet in Google Sheets, you rarely have all your data perfectly organized from the very beginning. As projects expand or new information becomes available, you will inevitably need to add new data points right in the middle of an existing dataset. Fortunately, you do not need to cut and paste hundreds of cells to make room. Google Sheets makes it incredibly simple to insert new, blank rows exactly where you need them, instantly shifting all existing data downward to accommodate the new space.

Method 1: Right-Click on the Row Number (Fastest)

The most direct and accurate way to insert a row is by interacting directly with the row numbers on the far left edge of your screen.

1. Open your Google Sheets document.
2. Look at the grey column on the far left side of the screen that contains numbers (1, 2, 3, etc.). These are the row headers.
3. Find the row where you want to insert new data.
4. Right-click directly on the grey number of that row. The entire row will highlight in blue, and a menu will appear.
5. In the menu, you will see two specific options:
   • Insert 1 row above: This will place a new, blank row immediately above the row you clicked, pushing the selected row down.
   • Insert 1 row below: This will place a new, blank row immediately below the row you clicked.
6. Click your preferred option. The new row will appear instantly.

Method 2: Using the Top Menu

If you prefer using the main navigation bar, you can achieve the exact same result using the “Insert” menu.

1. Click anywhere inside a cell near where you want to add the new row. You do not need to highlight the whole row.
2. Look at the menu bar at the very top of the screen and click on Insert.
3. In the drop-down menu, hover your mouse over the Rows option.
4. A smaller menu will appear to the side, giving you the same two choices: Insert 1 row above or Insert 1 row below.
5. Click the option you need. The row will be inserted relative to the single cell you currently have selected.

Method 3: How to Insert Multiple Rows at Once

If you need to add five new names to a list, inserting rows one by one is tedious. You can insert multiple rows simultaneously by highlighting them first.

1. Look at the grey row headers on the left.
2. Click and drag your mouse down the numbers to highlight the exact number of rows you want to insert. For example, if you want to insert three new rows, highlight rows 4, 5, and 6.
3. Right-click anywhere inside the highlighted blue row numbers.
4. The menu will now adapt to your selection. Instead of “Insert 1 row,” it will say Insert 3 rows above or Insert 3 rows below.
5. Click the desired option, and three blank rows will be created at once.