How To Merge Cells In Excel 4 Easy To Follow Steps

For example, if you want to merge cells A1, B1, and C1, you would click and drag from A1 to C1, highlighting all three cells. The cells you merge must be touching each other. For example, you can merge A1 with B1, but not A1 with only C1.

Merging cells is a great way to add formatting to an Excel spreadsheet. For example, you could put “July Calendar” at the top of an Excel calendar.

If you don’t want to center the cells’ content: Click the ▼ icon to the right of the Merge & Center button. Select a merge option. Merging cells only keeps the top left cell value. The other values will be deleted.

Select the merged cell. Go to the Home tab. Click the ▼ icon next to the Merge & Center button. Select Unmerge Cells.