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