problem sorting data, says "this operatioin requires merged cells to be identically sized"

P

parman

Need help with problem sorting data

Error message says "this operatioin requires merged cells to be
identically sized"


After identically resizing the merged cells (which were in the header
row), I still get this error message.
 
D

Dave Peterson

If the merged cells are only in the header, select your range (avoid the header)
and tell excel that your selection doesn't include headers (at the bottom of
that dialog).
 
P

parman

I guess that's what I have to do although the error message should say
something like "you can't sort merged cells . . " - ty
 
Top