Merged Cells Prevent sorting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jayceejay - 14 Feb 2007 16:57 GMT

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?

Reply to this Message

Gary''s Student - 14 Feb 2007 17:30 GMT

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

clear the merge checkbox

Signature

Gary's Student
gsnu200706

> 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."
[quoted text clipped - 4 lines]
> that I can perform what I thought was going to be a simple sorting of date on
> a single field?

Reply to this Message

Gord Dibben - 14 Feb 2007 17:39 GMT

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

>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."
[quoted text clipped - 4 lines]
>that I can perform what I thought was going to be a simple sorting of date on
>a single field?

Reply to this Message