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 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 .

   

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

   

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