Ask Your Question

How to cut and insert rows efficiently without dragging-and-dropping [closed]

asked 2016-12-05 19:05:04 +0100

Y33sha gravatar image

updated 2020-09-16 12:23:11 +0100

Alex Kemp gravatar image


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


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-16 12:23:20.783000


The relevant docs are and 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 gravatar imageNemo_bis ( 2017-02-15 12:13:08 +0100 )edit

@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 gravatar imageholy-harp ( 2019-11-10 18:28:09 +0100 )edit

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

holy-harp gravatar imageholy-harp ( 2019-11-10 18:37:39 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-12-05 22:58:30 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more


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

Y33sha gravatar imageY33sha ( 2016-12-06 12:59:27 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2016-12-06 16:15:48 +0100 )edit

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

holy-harp gravatar imageholy-harp ( 2019-11-10 18:29:59 +0100 )edit

Question Tools

1 follower


Asked: 2016-12-05 19:05:04 +0100

Seen: 1,075 times

Last updated: Dec 05 '16