Ask Your Question
1

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

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

Y33sha gravatar image

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.

edit retag flag offensive close merge delete

Comments

The relevant docs are https://help.libreoffice.org/Common/D... and https://help.libreoffice.org/Calc/Mov... 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
0

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 449 times

Last updated: Dec 05 '16