Add or move columns & cells

Want advanced Google Workspace features for your business?

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.
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:
1. Highlight 5 rows.
2. Right-click anywhere on those rows.
3. Select Insert 5 rows above or below.

To add 100+ rows to your spreadsheet:

On your computer, open a spreadsheet in Google Sheets.
Select a row or column to resize. To highlight multiple rows or columns:
- Mac: ⌘ + click the rows or columns
- Windows: Ctrl + click the rows or columns
Right-click the row number or column letter.
Click Resize row or Resize column. Then, choose an option:
- Enter a custom height or width
- Fit to data
Click OK.

You can also drag the edge of a row or column to resize it or double-click the row or column edge to fit to data.

Add more than one row, column, or cell gif

You can also drag a row or column to a new location.

On your computer, open a spreadsheet in Google Sheets.
Right-click a row, column, or cell.
From the menu that appears, choose Delete row, Delete column, or Delete cell.