E.g. I have this:
and I want this:
I tried Insert Rows Below, but that doesn’t carry the current row’s merges.
There’s Cut, Insert Rows Above, Paste - but as expected that messes up references.
I find no way to copy and paste parts of merges.
Starting from selected 3rd row:
- ⇒Insert Row above
- c4 ⇒ ctrl+x
-
c3 ⇒ ctrl+v
done
Thanks. That works, except on the first row:
