Insert Row and Maintain Merged Cells

  • Thread starter Thread starter TEAM
  • Start date Start date
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!!
 
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
 
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
 
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
 
Back
Top