Add or move columns and cells

Want to get more out of Google Docs for work or school? Sign up for a free Google Workspace trial.

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 that you want to add. To highlight multiple items:
    • Mac: ⌘ + click the rows or columns. 
    • Windows: Ctrl + click the rows or columns
  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 that you’d like to add.
  3. Click Add.
Change row height or column width
  1. On your computer, open a spreadsheet in Google Sheets.
  2. 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
  3. Right-click the row number or column letter.
  4. Click Resize row or Resize column. Then, choose an option:
    • Enter a custom height or width
    • Fit to data
  5. 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.

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 that 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 articles

 

Was this helpful?
How can we improve it?