I'm sure there must be a better, more sophisticated, way to find out but I
use the Find function:
Press Ctrl + "F" to open the Find box. Click "Format" button and select
"Alignment" tab. Check "Merge Cells".
This allows you to find all the merge cells one by one.
Alternatively, if you're sure you don't want any merged cells, you can
select your whole worksheet, go to Format Cells Alignment tab and uncheck
the "Merge Cells" box. You should then get a message asking if you're sure
you want to unmerge your cells...

Hope this helps.

"75gator" wrote:

How do I determine what has been merged and then unmerge it?

"Melissa" wrote:

What the error message means is that you have merged some cells in your table
and therefore, sorting can be done. You must unmerge those cells before
continuing.

"75gator" wrote:

I want to SORT a worksheet by a column that is formatted as a date. I keep
getting the following message whenver i try, "This operation requires the
merged cells to be identically sized".

So i copied all the cells into a new worksheet that had all cells in default
sixe format. Result was the same.

What am I doing wrong?