How I sort data in Excel, it keeps saying "merged cells must be ID

[Guest]

How I sort data in Excel, it keeps saying "merged cells must be identical
size?" I know what merged cells are and I'm pretty sure I DON'T have any in
the data I'm trying to sort. I've sorted data before and never run into this.
Is there a way I can check for what Excel is considering to be merged cells,
i.e. a find for merged cells?
I'm using Excel 2002 on Win XP Pro.

 

[Peo Sjoblom]

Select your table/list, press ctrl + 1, click alignment, if you have merged
cells that would now be indicated by the merge cells box, click twice in
that box to unmerge

--
Regards,

Peo Sjoblom

(No private emails please)

 

[David McRitchie]

Hi Angela,
Rather than finding the merged cells, if it is not important to preserve them
you could select the entire range perhaps Ctrl+A (except in Excel 2003
which is foobared and you would use Ctrl+Shift+Spacebar instead).

Then format, cells, alignment, uncheck merged cells
(you may have the check the option then uncheck it).

Misread it. You might try turning on gridlines and look for merged cells.

Are there any shape objects on the page. Does Ctrl+End match where
you think the end of the used range should be.