Merged Cells Prevent sorting
 

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?

Merged Cells Prevent sorting
 

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

clear the merge checkbox
--
Gary's Student
gsnu200706


"jayceejay" wrote:

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?

Merged Cells Prevent sorting
 

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

On Wed, 14 Feb 2007 08:57:00 -0800, jayceejay
wrote:

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?