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!!