You can add, change, move, or delete your spreadsheet's columns, row, or cells.
Add one row, column, or cell
- On your computer, open a spreadsheet in Google Sheets.
- Select a row, column, or cell.
- Right-click the row, column, or cell.
- From the menu that appears, select Insert 1 left, right, above or below.
Add more than one row, column, or cell
- On your computer, open a spreadsheet in Google Sheets.
- Highlight the number of rows, columns, or cells you want to add. To highlight multiple items:
- Mac: ⌘ + click the rows or columns.
- Windows: Ctrl + click the rows or columns
- Right-click the rows, columns, or cells.
- From the menu that appears, select Insert [Number] or Insert cells.
For example:- Highlight 5 rows.
- Right-click anywhere on those rows.
- Select Insert 5 rows above or below.
To add 100+ rows to your spreadsheet:
- On your spreadsheet, scroll to the bottom.
- Next to "more rows at the bottom," enter the number of rows you’d like to add.
- Click Add.
Related articles