Sort
 

When trying to sort a worksheet, a box is displayed saying "This
operation requires the merged cells to be identically sized".

(The data in this worksheet was copied from a number of other
worksheets).

In the current worksheet, how do I find which the merged cell(s)?

Sort
 

If you don't think there should be any merged cells on the sheet at all, the
simplest way to remove them is to highlight the entire sheet (or highlight
all your data) and then click the Merge cell toggle button on the toolbar to
ensure all merges are cancelled.

Failing that, if there should be some merged and not others, try
highlighting all your data and adding complete borders (with inner
borderlines) to it. This should make it easy to see the cell that is larger
than the others.

"GARY" wrote:

When trying to sort a worksheet, a box is displayed saying "This
operation requires the merged cells to be identically sized".

(The data in this worksheet was copied from a number of other
worksheets).

In the current worksheet, how do I find which the merged cell(s)?