Find merged cells

Sometimes worksheets have merged cells that you don’t know about. This can get frustrating because Excel can’t sort data in a column that has merged cells. But you can find all the merged cells in your worksheet with the Find command, and then unmerge those cells.

  1. Click Home > Find & Select > Find.

  2. Click Options>Format.

Find dialog box

  1. On the Alignment tab, under Text control, check the Merge cells box, and then click OK.

Check the Merge box

  1. Do one of the following:

  2. Click Find Next to find the next merged cell.

  3. Click Find All to see a list of all merged cells in your worksheet.

Find all merged cells

When you click an item in the list, Excel selects the merged cell in your worksheet.

After you’ve found the merged cells in your worksheet, you might want to unmerge them.

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!