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 Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Select a row or column.
  3. 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 Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Touch and hold the row or column you want to resize.
  3. In the menu that appears, tap Resize row or Resize column.
  4. Enter the row height or column width.
  5. Tap Save.

You can also tap a row or column and drag the edges.

Freeze or unfreeze rows or columns

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

  1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Touch and hold a row or column.
  3. In the menu that appears, tap Freeze or Unfreeze.
Move rows or columns
  1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Select 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 Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Touch and hold the rows or columns to merge.
  3. In the menu that appears, tap Merge Merge cells.

Delete, group, or hide rows or columns

Delete rows or columns
  1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Touch and hold the row or column you want to delete.
  3. In the menu that appears, tap Delete.

Group or ungroup rows or columns

  1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Highlight the rows or columns you want to group or ungroup.
  3. Touch and hold the highlighted rows or columns.
  4. Tap More More and then tap 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 Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Touch and hold a row or column.
  3. In the menu that appears, tap 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?