Add or move columns & cells in a spreadsheet

You can add, change, move, or delete your spreadsheet's columns, row, or cells.

Add one row, column, or cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row, column, or cell.
  3. Right-click the row, column, or cell.
  4. From the menu that appears, select Insert 1 left, right, above or below.

Add more than one row, column, or cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the number of rows, columns, or cells you want to add.
    • To highlight multiple items, press and hold the command key on your keyboard and click the rows, columns, or cells you want to highlight.
  3. Right-click the rows, columns, or cells.
  4. From the menu that appears, select Insert [Number] or Insert cells. For example, highlight 5 rows, right-click the row header, and then select Insert rows.

To add 100+ rows to your spreadsheet:

  1. On your spreadsheet, scroll to the bottom.
  2. Next to "more rows at the bottom," enter the number of rows you’d like to add.
  3. Click Add.

Note: You can add up to 40,000 rows at a time.

Change row height or column width
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column to resize. You can also highlight multiple rows, columns, or cells.
    • To highlight multiple rows, columns, or cells, press and hold the command key on your keyboard and click the rows, columns, or cells you want to highlight.
  3. Right-click the row number or column letter, then select Row height  and then Custom or Resize column.
  4. In the window that appears, enter a new height or width.
  5. Click Ok.

You can also drag the edge of a row or column to resize it.

Move rows, columns, or cells

Move rows or columns

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the rows or columns to move.
  3. At the top, click Edit.
  4. Select the direction you want to move the row or column, like Move row up.

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

Move cells

  1. Select the cells to move.
  2. Point your cursor to the top of the selected cells until a hand appears.
  3. Drag the cells to their new location.
Delete rows, columns, or cells
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Right-click a row, column, or cell.
  3. From the menu that appears, choose Delete row, Delete column, or Delete cell.

Related article

 

Andrew is a Docs and Sheets expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?
How can we improve it?