Insert Row and Maintain Merged Cells
 

When I insert a row, Excel repeats the formatting for the row it is
inserted next to. However, the merged property is not carried over.
Is there a setting or method for inserting a row and carrying over the
merge property? I know that it can be done with macros...any other
methods??


Thanks!!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=475033

Hi,

First select the entire row containing the merged cells (by clicking on the
row number on the left-hand side of the sheet), copy the row, righ-click on
the row number at the insertion point, and select "Inser Copied Cells".

Regards,
B. R. Ramachandran

"TEAM" wrote:


When I insert a row, Excel repeats the formatting for the row it is
inserted next to. However, the merged property is not carried over.
Is there a setting or method for inserting a row and carrying over the
merge property? I know that it can be done with macros...any other
methods??


Thanks!!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=475033

Hi,

A followup on my earlier reply to your posting.

I forgot to mention that the inserted row will contain not only the merged
formats. etc., but also the contents of the original row. So, after
'nserting the copied cells, you have to delete the contents in the newly
inserted row

REgards,
B. R. Ramachandran

"TEAM" wrote:


When I insert a row, Excel repeats the formatting for the row it is
inserted next to. However, the merged property is not carried over.
Is there a setting or method for inserting a row and carrying over the
merge property? I know that it can be done with macros...any other
methods??


Thanks!!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=475033

Hi,
It looks, my last response (followup to my earlier reply), for some reason,
didn't go through.
I forgot to mention that the newly inserted row will have the contents of
the original row along with the merged cell formats. So after inserting the
copied row, delete the contents in the new row.

Regards,
B. R. Ramachandran

"TEAM" wrote:


When I insert a row, Excel repeats the formatting for the row it is
inserted next to. However, the merged property is not carried over.
Is there a setting or method for inserting a row and carrying over the
merge property? I know that it can be done with macros...any other
methods??


Thanks!!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=475033

See
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/excel.htm
it will repeat the row with the active cell, with formatting and
formulas by inserted below the row with the active cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TEAM" wrote in message
...

When I insert a row, Excel repeats the formatting for the row it is
inserted next to. However, the merged property is not carried over.
Is there a setting or method for inserting a row and carrying over the
merge property? I know that it can be done with macros...any other
methods??


Thanks!!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=475033