For the second part to delete rows having empty cells, you have to filter it first and select only blanks from the filter then manually delete the rows.