How do I view the formatting of a cell
 

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?

How do I view the formatting of a cell
 

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?

How do I view the formatting of a cell
 

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?

How do I view the formatting of a cell
 

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?

How do I view the formatting of a cell
 

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?