To fix a spill error caused by merged cells, unmerge the cells in the spill range by going to the Home tab and selecting “Unmerge Cells” under the Merge & Center option.