Merge cells

Merging combines two or more cells to create a new, larger cell. This is a great way to create a label that spans several columns. For example, here cells A1, B1, and C1 were merged to create the label “Monthly Sales” to describe the information in rows 2 through 7.

Merge cells above other cells

  1. Click the first cell and press Shift while you click the last cell in the range you want to merge.

    Important: Make sure only one of the cells in the range has data.

  1. Click Home > Merge & Center.

merge and center button on the ribbon

If Merge & Center is dimmed, make sure you’re not editing a cell or the cells you want to merge aren’t inside a table.

Tip:  To merge cells without centering the data, click the merged cell and then click the left, center or right alignment options next to Merge & Center.

If you change your mind, you can always undo the merge by clicking the merged cell and clicking Merge & Center.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!