Select a row by clicking on its number on the left-hand side
2
With the desired row selected, right-click to open a context menu
In the menu, click the option "Insert 1 row above" or "Insert 1 row below" according to your preferences
3
Review the results
How to Add a Single Row Using Menu Features
4
Select a row by clicking on its number on the left-hand side
5
With the desired row selected, click "Insert"
6
From the drop-down menu, select "Rows"
7
Click the option "Insert 1 row above" or "Insert 1 row below" according to your preferences
How to Add Multiple Rows Using the Right Click
8
To insert multiple rows, highlight the same number of existing rows, columns, or cells you wish to add
- On **Mac**, hold **⌘** and click the rows to select them
- On **Windows**, hold **Ctrl** and click the rows
9
After selecting the items, right-click anywhere within the highlighted area
In the menu, click the option "Insert (x number) rows above" or "Insert (x number) rows below" according to your preferences
How to Add Multiple Rows Using Menu Features
10
To insert multiple rows, highlight the same number of existing rows, columns, or cells you wish to add
- On **Mac**, hold **⌘** and click the rows to select them
- On **Windows**, hold **Ctrl** and click the rows
11
With the desired rows selected, click "Insert"
12
From the drop-down menu, select "Rows"
13
Click the option "Insert (x number) rows above" or "Insert (x number) rows below" according to your preferences
How to Add 100 or More Rows
14
Navigate to the bottom of your spreadsheet
15
At the bottom of the sheet, look for the field labeled “more rows at the bottom”