How to Unmerge Combined Cells

Merged or combined cells trip our importer so it’s important to remove them before uploading your data. Continue reading to find out how it’s done.

This is how a merged/combined cell looks like.

1. The first thing that you need to do is to highlight the cells that you have to unmerge.

2. Then go to Home, click the Merge & Center dropdown button (arrow down icon), and select Unmerge Cells.

3. Or, do a right click on your mouse after highlighting the cells, then select Format Cells, go to Alignment, uncheck the Merge Cells button, and click OK.

The cells are now unmerged. Delete the extra fields, and you’re ready to upload your data.