Finding merged cells in Excel

Were you ever prevented from sorting records in Excel because of merged fields? Well, if you just want to remove all merged fields, you can just select all cells in the worksheet, click Format>>Cells, and clear the Merge cells checkbox.

If you prefer to take care of each merged cell individually, to avoid unintended consequences, try this (written for Excel 2003):

1.  Open the Find and Replace dialog box.

2.  Click Options.

3.  Click Format (to the right of the Find what field).

4.  On the Alignment tab, click Choose format from cell. 

5.  Click a merged cell.

A list of merged cells is displayed in the lower pane of the Find dialog box. Click one to navigate to that reference.