This is (slightly) different from a similar topic about a year ago I found here.
If I copy data from a single cell, say, C1 into E1 which is a cell merged with F1, all seems to work ok. But if I try to copy C1:C3 into E1:E3 in a single block copy, the data copies across into E1:E3 but F1:F3 become demerged and the data replicated there. Anything other than copying a single cells "fails" in this way.
Any way of preventing this?
If I copy data from a single cell, say, C1 into E1 which is a cell merged with F1, all seems to work ok. But if I try to copy C1:C3 into E1:E3 in a single block copy, the data copies across into E1:E3 but F1:F3 become demerged and the data replicated there. Anything other than copying a single cells "fails" in this way.
Any way of preventing this?