Clearing contents removes data or formatting from cells without altering the structure of the spreadsheet, while deleting cells removes the cells themselves, potentially affecting the layout or structure of the spreadsheet.