Inserting Rows in Excel 2003

[Guest]

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,

 

[Guest]

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

 

[Guest]

Wow, I have been using this application for many years and every day I learn
something new. Since I never had a need to insert merged rows I had no idea
it was not possible. I'm open for any workarounds anyone may have figured
out.

Thanks Dave for the quick response.

 

[Guest]

One possibility is to insert the rows you want, then copy a row with the
relevant merged cells and paste special the format onto the inserted rows.
This would replicate the formatting of the row you copied.

Dave

 

[David McRitchie]

Hi Marilyn,
I don't know where you saw a setting "Format as Above"
(I have Excel 2002), but to do what you want see
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

The macro will copy the row you are on, inserting the
number of rows you request in the dialog reply below the
current row. So you will have the same formatting. The
macro retains only the formulas for the insert rows by removing
the constants from the inserted rows.

 

[Guest]

I will give that a try as well.

thanks to ALL for the quick responses!