Merging and unmerging cells in Microsoft Excel is a great way to keep your spreadsheet clean, well-organized, and easy to understand. The most common use is creating a header to identify the content across several columns, but no matter the reason, it can quickly be done in Excel.
Note that Excel doesn’t allow you to split a cell the same way that you can in a table in Microsoft Word. You can unmerge cells that you have previously merged.
Merging Cells
Merging cells combines two or more cells into a single cell. To do this, select the cells you want to merge.
Next, on the “Home” tab, click the “Merge and Center” button.
As the name implies, this will merge the selected cells. Any text in the cells will be centered by default.
