DemoClick

How to merge cells in Excel

Interactive walkthrough — 3 steps. Click through at your own pace.

Your version:
AutoSave ●Book1 — Excel—▢✕
HomeInsertPage LayoutFormulasDataViewReviewDraw
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
A1fx
ABCD
1Q1 Sales Report
2NameRegionSalesDate
3Ava ChenWest12,400Mar 3
4Ben OrtizEast9,880Mar 4
5Cara NgWest15,220Mar 5
6Dan ParkNorth7,410Mar 6
7Elle KimSouth11,030Mar 7
8Finn RossEast8,650Mar 8
Sheet1Ready100%

Simplified simulation — your Excel may show more buttons.

1

Drag across the cells you want to merge — here A1 to D1, the row holding the title.

The title sits in A1 only; B1 to D1 are empty, so nothing gets discarded.

Steps in text

  1. Drag across the cells you want to merge — here A1 to D1, the row holding the title.
  2. Click Merge & Center.
  3. The four cells become one, with the title centred across them.

More Excel walkthroughs

How to freeze the top row in Excel

5 steps

How to freeze a row in Excel

6 steps

How to freeze a column in Excel

6 steps