Merging cells is an easy way to format your Excel spreadsheets, and you can do it vertically and horizontally.
For example, a merged cell at the top of a table can work as a header or it can delineate a category. Merging will group the cells, so they work as an individual cell.
How to merge cells in Excel
How do I unmerge cells?
Click on the merged cell to select it, and go to the same Merge & Center button.
Clicking this button will separate the merged cells automatically, though a dropdown menu to the right will give you the option to Unmerge Cells.
How can I combine full columns or rows?
You can merge columns or rows by selecting them and clicking Merge & Center in the Home tab on Excel.