Merge Adjacent Cells in Excel

Question

How to merge adjacent cells in Excel?

Answer

  1. Select two or more adjacent cells that you want to merge. 
  2. On the Home tab, in the Alignment group, click Merge & Center.

The cells will be merged in a row or column, and the cell contents will be centered in the merged cell.  To merge cells without centering, click the arrow next to Merge and Center, and then click Merge Across or Merge Cells.

If the Merge and Center button is unavailable, the selected cells may be in editing mode.  To cancel editing mode, press ENTER.

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: 7886
Created
Thu 12/22/22 12:58 PM
Modified
Fri 11/3/23 3: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 (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.