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?

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?

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?

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?

I am unable to click the merge button twice as it is not available it is
shaded with a check mark in the box. I have gone to other cells within the
worksheet and it appears that all of the cells have the merge box check with
it shaded so it is not availabe to click. This worksheet is linked to two
different workbooks with various worksheets in them. Could this have
something to do with the merge problem I am having

"Gord Dibben" wrote:

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?