26
Why merged cells cause so much trouble, and the setting that gives you the look without the damage
The hostility is not aesthetic. A merged cell breaks a set of operations that everything downstream depends on. What it actually breaks Sorting. A range containing merged cells either refuses to sort or scrambles,…