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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top