Unmerge the cells first

*Soapbox alert*
Merging cells is the cause of much more pain than gain and most power users
& MVPs who post here will urge, encourage, and advise you to merge cells only
when absolutely needed.


"Ron" wrote:

How do I sort an Excel worksheet containing merged cells?