Sorry, I meant sorting CANNOT be done if cells are merged.

"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?