Split a Merged Cell in Excel

Summary

How to split merged cells in Excel?

Body

Question

How to split merged cells in Excel?

Answer

  1. Select the merged cell. When you select a merged cell, the Merge and Center button also appears selected in the Alignment group on the Home tab.
  2. To split the merged cell, click Merge and Center.
  3. The contents of the merged cell will appear in the upper-left cell of the range of split cells.

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.

Details

Details

Article ID: 7887
Created
Thu 12/22/22 2:14 PM
Modified
Fri 11/3/23 4:42 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

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.