the simple way is:
- select all cells of the table which you want to sort data;
- click menu Format \ Cell, and unchecked the Merge cell in Alignment tab

now you can use sorting function ok

"tvanellen" wrote:

I received a large xl-file, in which I want to execute some sorting
operations. However, I get the error message that "this operation requires
the merged cells to be identically sized". I guess some cells are merged, but
does anybody know how I can quickly find the merged cells?