Merged Cells Prevent sorting

[Guest]

I'm trying to sort upon a given column and I get the error message stating
that "Merged cells must be of the same size."

I know what merged cells are, but the problem is, I cannot find ANY cells in
the column in which I am sorting that are merged. So does this rule apply to
ANY CELL in ANY column? If so, how do I bypass or shut off this feature so
that I can perform what I thought was going to be a simple sorting of date on
a single field?

 

[Guest]

Select all the cells in the entire worksheet and in Format > Cells...

clear the merge checkbox

 

[Gord Dibben]

Generally Excel will select the current region to sort.

Your sort range could include other columns which contain merged cells.

Insert columns to left and right of the given column then sort just the given
column.


Gord Dibben MS Excel MVP