Ask Your Question

Copy Data in-between

asked 2018-09-19 14:37:19 +0200

Emoh gravatar image

Is there a way to insert some data into a range; shifting the range down after inserting?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-19 16:13:12 +0200

Lupp gravatar image

updated 2018-09-19 16:20:53 +0200

You need to do the shift first and to paste/enter/whatever your data/formulae/whatever subsequently.
You didn't name your LibO version (Please always do!), and the UI may have changed insofar within the last year.
With recent versions select the range you want to shift and go > Sheet > Insert Cells and select the mode.
LibO will refuse to shift non-empty cells off the sheet.

Using Paste Special... (Ctrl+Shift+V) you also get offered the option to perform a preparing shift operation in advance by the same command. Inpermissible shifts will then not be offered for selection at all.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-19 14:37:19 +0200

Seen: 18 times

Last updated: Sep 19 '18