Merge and unmerge cells

Merging combines two or more cells to create a single, larger cell. This is a great way to create a label that spans several columns. To merge cells, follow these steps:

  1. Drag the selection handle Selection handle to select the cells that you want to merge. For example, drag the handle from cell A1 to cell C1.

  2. On your iPad, tap Merge .

    Unmerging cells

    On your iPhone, tap the Edit icon Tap to see the ribbon , tap Home if it isn't already selected, and then tap Merge & Center.

    Merge and center command

Important: Only the data in the upper-left cell from a range of selected cells remains in the merged cell. Excel deletes data in the other cells of the selected range.

If Merge or Merge & Center is not available on the Home tab, make sure that the cells you want to merge aren’t inside a table.

If you change your mind, you can always unmerge the cells.

  1. Select a merged cell.

  2. On the Home tab, tap Merge or Merge & Center again.

If Merge or Merge & Center is not available on the Home tab, then the selected cell might not be a merged cell.

Do you have a specific function question?

Post a question in the Excel community forum

Help us improve Excel

Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice

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!

×