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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

parman - 08 Oct 2004 22:55 GMT

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.

Reply to this Message

Dave Peterson - 09 Oct 2004 00:18 GMT

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).

> Need help with problem sorting data
>
[quoted text clipped - 3 lines]
> After identically resizing the merged cells (which were in the header
> row), I still get this error message.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

parman - 12 Oct 2004 04:04 GMT

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

>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
[quoted text clipped - 7 lines]
>> After identically resizing the merged cells (which were in the header
>> row), I still get this error message.

Reply to this Message