Find merged cells
Applies To: Excel 2013
- Click Home > Find & Select > Find.
- Click Options>Format.
- On the Alignment tab, under Text control, check the Merge cells box, and then click OK.
- Do one of the following:
- Click Find Next to find the next merged cell.
- Click Find All to see a list of all merged cells in your worksheet.
When you click an item in the list, Excel selects the merged cell in your worksheet.