There's no setting you're missing. Excel doesn't deal with merged cells very
well, and one way this is shown is with the discrepancy you're describing.
Rows are always inserted un-merged.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Marilyn" wrote:

Hi All,

I have a workbook where I have Columns F2:K2 merged I also have the same
columns merged for rows 3, 4, 5, 6, and 7. When I insert a new row in that
area I choose to "Format Same as above" however, the cells in columns F:K are
not merged like the ohers. I would like the new inserted rows to have merge
cells from columns F:K.

Is there a setting that I'm missing?

Thanks,