sort error message in excel

N

Nicole_Lipnicki

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I'm trying to sort my data as I have done a million other times but now this error messages comes up:
"This operation requires the merged cells to be identically sized."
I'm not sure what its problem is and how to rectify it.
I use this data to merge into labels but the raw data within the spreadsheet is just data - no formulas, etc..
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I'm trying to sort my data as I have done a million other times but now this
error messages comes up:
"This operation requires the merged cells to be identically sized."
I'm not sure what its problem is and how to rectify it.
I use this data to merge into labels but the raw data within the spreadsheet
is just data - no formulas, etc..
Click to expand...

The error is telling you that you have merged cells mixed in with your
unmerged cells.

Unmerge all cells (or only select unmerged cells before sorting).

This is only one reason that merged cells should never be used...
 
Top