Click the merge button twice.


Gord Dibben MS Excel MVP

On Tue, 31 Oct 2006 08:28:01 -0800, Debi wrote:

The unmerge botton is not available it is shaded with a check mark in the box

"hot dogs" wrote:

Try selecting the entire range, then un-merging the cells, however this will
un-merge all cells within the range.

"Debi" wrote:

I am attempting to insert cells in to a row where cells are already formated
when I do it does not change the formulas to include the incerted cells. When
I look at the formateing going to formate cell all I see is merge check
however it is not available to deselect. How to I view which cells are merged
togather?