Unmerge so I can sort

P

PaulH7436

I coy/pasted data into Excell and when I try to sort it I get "This operation
requires merged sells to be identically sized". I understadn the work around
in KB but how do I find which sells are merged?
 
D

Dave Peterson

I wouldn't bother looking.

I'd just remove all the merged cells from the range to sort.

Select that range
format|cells|alignment tab
uncheck the merge cells box

But if you wanted to search, you can do it via process of elimination. Select a
range, format|cells|alignment tab.

If that merge cells box is checked, then the whole selection is merged. If it's
grey, then part of that selection is merged. If it's clear, then no merged
cells in the selection.
 
Top