Insert or delete rows or columns in a sheet

Insert or delete rows or columns in a sheet

Insert a row or column in your spreadsheet

To insert a row or column:
  1. Select a row or column in your spreadsheet where you wish to insert a row.
  2. Go to Home > Insert .
  3. From the drop-down, choose Insert Row or Insert Column as needed.
    Alternatively, you can right-click on a cell and choose Insert Row or Column from the contextual menu.
  4. Select if you want the row to be inserted above the selected row or below the selected row.

Delete a row or column in your spreadsheet

To delete a row or column:
  1. Select a column or row you wish to delete.
  2. Go to Home > Delete  .
  3. From the dropdown, choose Delete Row or Delete Column as needed.
    Alternatively, you can right-click on a cell and choose Delete Row or Column from the contextual menu.