Spreadsheets: Adding or Deleting Rows or Columns To insert a new row or column, simply highlight the entire row, then use the keyboard shortcut “Control” + “+”. To delete a row, simply highlight the row, then type “Control” + “-“. Exactly the same procedure applies for adding or deleting columns.