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


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?)


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.

@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.

@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.

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.

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

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

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