If the "Merged Cells" box has a check mark in it, grey or black, it means
that you *now* have merged cells somewhere.
The check mark is black if the *entire* selection *is* merged.
The check mark is grey if the *entire* selection contains merged cells *and*
unmerged cells.
So, follow this:
Select some cells and merge them.
Go back and select *only* the merged cells.
You'll now see that the check is black.
Click on it, and it will become de-selected, and disappear, and the cells
become unmerged.
Now again, select some cells and merge them.
Go back and select the merged cells *and* some others.
You'll now see that the check is grey, meaning that *not everything* in the
selection is merged.
Move the dialog box to a corner of the screen, so that you can see your
selection that contains both the merged and unmerged cells.
NOW ... click on the grey check.
It turned BLACK, AND, the entire original selection NOW became merged.
Click the check mark (now black) a *second* time.
The check mark disappears, and the merged cells become unmerged.
So, what you need to do is select your entire sheet, click on the grey check
mark *twice*, so that it really merges the entire sheet, and then unmerges
the entire sheet.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
thanks but....maybe this is because I have excel 97 that its not acting the
way you think it should. Dave's instructions specifically say "...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.) Well I have grey checkmarks which means I "had" a mixture
of merged cells and regular unmerged cells and we're assuming they are gone
now...hence the "had" ?
So now I select the entire sheet and go to data-sort and sort by state,town
and name is ascending order. Immediately the warning comes up "all merged
cells must be idetically sized for this operation (paraphrasing) and it WILL
NOT sort them. Any thoughts???