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.

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.