Insert Row and Maintain Merged Cells

T

TEAM

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

B. R.Ramachandran

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
 
B

B. R.Ramachandran

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
 
B

B. R.Ramachandran

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
 
Top