Inserting Rows in Excel 2003
 

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,

Inserting Rows in Excel 2003
 

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,

Inserting Rows in Excel 2003
 

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.

"Dave F" wrote:

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,

Inserting Rows in Excel 2003
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Marilyn" wrote:

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.

"Dave F" wrote:

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,

Inserting Rows in Excel 2003
 

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marilyn" wrote
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.

Inserting Rows in Excel 2003
 

I will give that a try as well.

thanks to ALL for the quick responses!


"David McRitchie" wrote:

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marilyn" wrote
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.