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.

As you can see, the A1, B1, and C1 cells have merged into one single cell. There are also other options to choose from. To access these options, click the arrow next to “Merge and Center” and a dropdown menu will appear.

These options are relatively straight-forward. One thing to note is that “Merge Across” merges only the selected cells in a row, but not the cells in a column.

So what happens if we merge cells that already have content in them? This is something you have to be very careful with. Merging cells with already-existing data only keeps the upper-left value and discards all other values. That means all data except the data in the upper-left cell will be deleted. Microsoft does give you a warning message before merging the cells, though, but do make sure you understand that the data will be lost before continuing.

Unmerging Cells

Unmerging cells splits previously merged cells back into single cells. Doing so is as easy as selecting the merged cells and then clicking the “Merge and Center” button again to toggle the setting off. Similarly, you can click the arrow next to “Merge and Center” to access the drop-down menu and then click “Unmerge Cells.”