Insert or delete cells, rows, or columns | Zoho Sheet for Android

Insert or delete cells, rows or columns in a sheet

To insert a column or a row: 

  1. Select the column or row before which you want to insert a new column or a row.

  2. Tap the  icon.

  3. Go to the Home menu. 

  4. Tap the Insert & Delete option.

  5. From there, choose to Insert Column or Insert Row.

  6. Alternatively, you can insert a column or row via contextual menu as well. 


To delete a column or a row: 

  1. Select the column or row you want to delete.

  2. Tap the  icon.

  3. Go to the Home menu.

  4. Tap the Insert & Delete option.

  5. From there, choose to Delete selected the row or column.

  6. Alternatively, you can delete a column or row via contextual menu as well.


To insert a cell range:  

  1. Select the cell range above/before which you want to insert cells.

  2. Tap the  icon.

  3. Go to the Home menu.

  4. Tap the Insert & Delete option.

  5. Choose if you want to Insert & Shift Cells Right or Insert & Shift Cells Down.

  6. You can also insert a cell range via the contextual menu.


To delete a cell range:
  1. Select the cell or cell range you want to delete.

  2. Tap the  icon.

  3. Go to the Home menu.

  4. Tap the Insert & Delete option.

  5. Choose if you want to Delete & Shift Cells Left or Delete & Shift Cells Up.

  6. Otherwise, you can delete a cell range via contextual menu as well.