Ask Your Question

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

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

Y33sha 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 close merge delete


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 +0200 )edit

1 Answer

Sort by » oldest newest most voted

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

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 +0200 )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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 304 times

Last updated: Dec 05 '16