sorting merged cell question
 

When I try to sort a spreadsheet I get a message that says "The operation
requires the merged cells to be identically sized". What does this mean?
--
Connie

sorting merged cell question
 

It means you have one or more sections of merged cells in the sort area.

When you get the error message click on "Show help" to get a couple of
suggestions.

Merged cells cause no end of problems with sorting, copying, pasting, filtering
and a host of other functions I can't remember off-hand.

My suggestion.....find the merged cells and un-merge them.

CTRL + a(twice in 2003) and FormatCellsAlignment. Uncheck the "merge cells"
option.


Gord Dibben MS Excel MVP


On Mon, 27 Nov 2006 05:58:02 -0800, cs2001
wrote:

When I try to sort a spreadsheet I get a message that says "The operation
requires the merged cells to be identically sized". What does this mean?