You have at least one merged cells (multiple cells made to look like just one
cell).

If you don't think you're using merged cells, maybe you can get rid of them.

Save your workbook (just in case you don't like the results).
Select the range to fix (or ctrl-a (twice in xl2003) to select all the cells)
Format|cells|Alignment tab|uncheck merge cells

(If that checkbox had a checkmark, then the selection was merged. If the
checkmark was grey, then you had a mixture of merged cells and "regular"
unmerged cells.)

Catt wrote:

I've got a new problem. When I try to sort my list which has company, city
and state Excel won't sort it I keep getting the message that "this operation
requires that merged cells must be identically sized". What merged cells? I
did nothing that I know of to prompt this message. No matter what I try it
won't do it. This is Excel 97. Can someone tell me why this is happening?
Thanks,
Catt

--

Dave Peterson