How to Merge Cells in MS Excel

Merge Cells in MS Excel

excelmergeacross003large 1024x599 1

Merging cells means combining two or more cells to get one single larger cell. This larger cell is used to insert large text or create a heading. You can merge cells by selecting the cells and clicking on of the Merge & Center tool in the Alignment group under the Home tab. This will open a drop-down list of various merging options available in Excel.

  • The Merge & Center option is used to merge selected cells and center the text.
  • The Merge Across option is used to merge selected cells without changing text alignment. The text remains left-aligned by default.
  • The Merge Cells option is used to merge the selected cells into one cell.
  • The Unmerge Cells option is used to split the merged cells. The larger merged cell again splits into smaller individual cells.