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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×