Add New Row in Google Sheets

How to insert new row in Google Docs spreadsheet?

Explanation

Add or insert the new row in the spreadsheet using the following options,
Option 1:
Step 1: Select the row and right click.
Step 2: Choose the option to insert the row above or below the selected row.

Option 2:
Step 1: Select the entire row.
Step 2: Click Insert → Row above/Row below

Option 3:
Step 1: Select the cell.
Step 2: Choose any of the above options to insert. Here, we have selected Insert → Row above / Row below.

Related Topics