Merging Options available in Excel
From above screen there are multiple options available for Merging the excel cell.
Merge & Center - This option allows you to Merge the multiple cells and keep the contents in the center of the cell.
Merge A1 and B1![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPb3Sm0BT9VUj1naG8T070U7CW-rGlYhXsleiXN-WYy-qQhJnnM77yzAH4mIIYVXlYEiSBvMalj43ipHT7-Qk9z6BZruRWp6oiJanlE-Ccim_bqko5VJCAdMNOCumgO06mO3VHj4wRJR0/s1600/47.png)
Merge Across - Merge the selected cells in to larger cells while keeping rows separate.
Merge Cells - Merges selected cell into one cell but does not align the text to the center.
Unmerge Cells - Unmerge the cells means which allows you reverse the smaller cells from the bigger cell.
From above screen there are multiple options available for Merging the excel cell.
Merge & Center - This option allows you to Merge the multiple cells and keep the contents in the center of the cell.
Merge A1 and B1
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPb3Sm0BT9VUj1naG8T070U7CW-rGlYhXsleiXN-WYy-qQhJnnM77yzAH4mIIYVXlYEiSBvMalj43ipHT7-Qk9z6BZruRWp6oiJanlE-Ccim_bqko5VJCAdMNOCumgO06mO3VHj4wRJR0/s1600/47.png)
Merge Across - Merge the selected cells in to larger cells while keeping rows separate.
Merge Cells - Merges selected cell into one cell but does not align the text to the center.
Unmerge Cells - Unmerge the cells means which allows you reverse the smaller cells from the bigger cell.