Sometimes, you would be required to find merged cells in Excel. One of the common cases is when you try to sort a column and all of a sudden of you see the pop-up regarding merged cell. You can do following to find merged cells –
1. Select the column.
2. CTRL+F and click Options.
3. Click on Format
4. Alignment tab > Remove ticks from Wrap Text and Shrink to Fit. Tick Merge Cells.
5. Now click Find Next to find if Column has merged cell or not.
