getting msg: cannot sort merged cells not same size
 

Hi. someone sent me what looks like a run of the mill excel file . When I
try to sort it I get a message saying the "operation requires merged cells to
be identically sized". All the cells look the same size to me and as far as I
know no merging was done to create the file.... I am attempting to contact
the creator of the file but so far no luck. any ideas? Thank you.

press Ctrl-A to select the entire sheet, then FormatCellsAlignment and make
sure the Merge Cells option is unchecked.

"help with mas data" wrote:

Hi. someone sent me what looks like a run of the mill excel file . When I
try to sort it I get a message saying the "operation requires merged cells to
be identically sized". All the cells look the same size to me and as far as I
know no merging was done to create the file.... I am attempting to contact
the creator of the file but so far no luck. any ideas? Thank you.