Merge or Split Cells in Excel

Question

How to merge or split cells in Excel?

Answer

Merging two or more adjacent horizontal or vertical cells makes the cells become one large cell displayed across multiple columns or rows. The contents of one of the cells appear in the center of the merged cell.

You can split a merged cell into separate cells again but you cannot split a single cell that has not been merged.
 

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.