sorting merged cell question

C

cs2001

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?
 
G

Gord Dibben

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 Format>Cells>Alignment. Uncheck the "merge cells"
option.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top