Edit rows, columns & cells in a spreadsheet

You can add, delete, group, freeze, move, or hide rows and columns in a spreadsheet in Google Sheets.

Add rows or columns

  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Select a row or column.
  3. To add a row or column, tap Insert Add.
  4. From the menu that appears, choose an option.

Change or move rows or columns

Change row height or column width
  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Select the row or column you want to resize.
  3. To resize, tap and drag the edge of the cell containing the row number or column letter.
Freeze or unfreeze rows or columns

Keep some data in the same place and still see it when you scroll.

  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Select and tap a row number or column letter.
  3. In the menu that appears, tap the Right arrow and then Freeze or Unfreeze.
Move rows or columns
  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Touch and hold the row number or column letter to move.
  3. Drag the row or column to a new place.
Combine rows, columns, or cells
  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Select and tap the rows, columns, or cells to merge.
  3. In the menu that appears, tap the Right arrow and then Merge rows, Merge columns, or Merge cells.

Delete, group, or hide rows or columns

Delete rows or columns
  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Select and tap the row or column you want to delete.
  3. In the menu that appears, tap the Right arrow and then Delete row or Delete column.

Group or ungroup rows or columns

  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Highlight the rows or columns you want to group or ungroup.
  3. Tap the highlighted rows or columns.
  4. In the menu that appears, tap the Right arrow and then Group or Ungroup.

To expand or collapse grouped rows or columns, tap the Plus (+) or Minus (-) sign. Note: If there is a group within a group, you will need to tap the Double arrows » first.

Hide rows or columns
  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Select and tap a row or column.
  3. In the menu that appears, tap the Right arrow and then Hide Row or Hide column.

Related article

 

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?