How to cut and insert rows efficiently without dragging-and-dropping

[Y33sha]

Hello,

I’m looking for a way to move rows (or columns) by cutting them and inserting them elsewhere.

I know about the ctrl+alt shortcut with the mouse, but I’m dealing with files containing thousands of rows, and I don’t want to drag the rows for ten minutes before dropping them.

I also don’t want to have to: 1) cut the content of the lines; 2) create new lines; 3) paste the lines; 4) and then scroll again to the previous location and remove the blank lines.

This procedure was easy and seamless on MS Word back when I used Windows; I don’t understand why it’s still not possible in LibreOffice. (Or am I just missing something?)

Thanks.

[Nemo_bis]

The relevant docs are Dragging and Dropping Within a LibreOffice Document - LibreOffice Help and Moving Cells by Drag-and-Drop - LibreOffice Help but at least for me they’re incomplete. 1) Select cells with ctrl + click or shift + arrow keys, 2) Start dragging the cells (not their headers) while holding ctrl-alt, 3) release the ctrl key, 4) move the area where you want and release. Indeed I have no idea how to select the target correctly.

[holy-harp]

@Nemo_bis, your method will move/copy the contents from a row/column to an existing row/column and overwrite the contents of that existing row/column. This will not to what @Y33sha (and I) would like.

[holy-harp]

@Y33sha, could you please improve your question. Please clarify the second paragraph. and delete the forth. You have asked a very good question. It deserves polishing.

[mariosv]

If you have not a common value on a column to filter the rows, in other column write something like ‘zzzz’ only on the rows to deleted, filter the rows for ‘zzzz’, select the rows and delete them.

[Y33sha]

I’m not sure I understand what you mean. I want to move rows, not delete them.

[mariosv]

Do you have any criteria on the data to sort them?

[holy-harp]

@mariosv Your answer must be for a different question. Please remove it.