Insert rows and keep merged cells in the inserted row

[Buggelsgaard]

Hi,
I have a simple spreadsheet with 15 columns and appr. 30 rows.

At Column D + E I have merged cells horisontally in almost every row -
except af few ones.
When I want to insert a new row(with merged cells), then it's inserted but
not merged.
I mark the row on the rownumber, rightclick the mouse and do "insert".

Can I do something, so the merged cells in the marked row will be copied
into the inserted row?

 

[David Biddulph]

Standard advice in this & other Excel newsgroups is don't use merged cells.
There is normally a better alternative.
In the archives of the group you'll find many more reports of problems than
you'll find solutions. It sounds like you've found one of the problems.