Merged cells can also make the spreadsheet look inconsistent or cause problems when importing and exporting data. To split the cells, start by selecting the merged cells on the sheet.