How locate merged cells in Excel

[LESTEREDEN]

I want to sort columns but some cells are merged. How do I locate the merged
cells - or is there a way of unmerging all merged cells?

[David Billigmeier]

Select all cells and hit the "merge" button, just like you were going to
merge those cells. If there are any merged cells within your workbook it
will unmerge them first.
--
Regards,
Dave


"LESTEREDEN" wrote:

> I want to sort columns but some cells are merged. How do I locate the merged
> cells - or is there a way of unmerging all merged cells?