I'm trying to use the Data function to sort a long catalogue. Each time I get
the message "this operation requires the merged cells to be identically
sized".
How do I find out which of the cells in the sheet are wrongly sized and
correct the problem which will then allow me to use the sort function?

Thanks

If you believe none of the cells should be merged then highlight your entire
data range and toggle the Merge button to off. You will then be able to sort.

DC

"cholm" wrote:

I'm trying to use the Data function to sort a long catalogue. Each time I get
the message "this operation requires the merged cells to be identically
sized".
How do I find out which of the cells in the sheet are wrongly sized and
correct the problem which will then allow me to use the sort function?

Thanks

That fixed it. Many thanks

"Dom_Ciccone" wrote:

If you believe none of the cells should be merged then highlight your entire
data range and toggle the Merge button to off. You will then be able to sort.

DC

"cholm" wrote:

I'm trying to use the Data function to sort a long catalogue. Each time I get
the message "this operation requires the merged cells to be identically
sized".
How do I find out which of the cells in the sheet are wrongly sized and
correct the problem which will then allow me to use the sort function?

Thanks