You really don't have to find anything!

Just follow Dave's instructions and select the *entire* sheet,
<<<"(or ctrl-a (twice in xl2003) to select all the cells)"
and then *unmerge*.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Catt" wrote in message
...
Ahhhh...is see now. The check mark was gray so that means there are some
cells that are merged and some that are not. I guess the question now is
how
do I find which cells are merged and "unmerge" them?
Thanks


"Dave Peterson" wrote:

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