Merging cells is a common task when creating reports in worksheets. But merged cells can play havoc with the normal functioning of some of Excel’s tools. Knowing where those cells are located could be helpful so that you can determine whether to remove them or not.

Here is one way to identify which cells are merged in a workbook.

You can use Excel’s searching capabilities. Follow these steps:
Press Ctrl+F. Excel displays the Find tab of the Find and Replace dialog box.
If necessary, click the Options button to make sure the Find and Replace dialog box is expanded to show all options.

Find dialog showing options

Make sure the Find What box is empty.
With the insertion point in the Find What box, click the Format button. Excel displays the Find Format dialog box.
Make sure the Alignment tab is displayed and check the Merge Cells check box.
Click OK to close the Find Format dialog box.
Click Find All.
Excel searches for any merged cells and if they are located, the cells are displayed in the bottom of the Find and Replace dialog box. You can then select one of the found ranges and the corresponding range is selected in the worksheet.