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

Details

Article ID: 7885
Created
Thu 12/22/22 12:56 PM
Modified
Fri 11/3/23 3:41 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

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.