Ask Your Question

Switch rows? (Calc) [closed]

asked 2017-04-01 04:53:10 +0100

appreciatethehelp gravatar image

If I have two rows in calc (say, rows 5 and 15) that I want to switch around (the information in 5 is moved to 15 and vice-versa) is there any function in libreoffice that allows this? I am doing a lot of this kind of switching in my documents.

What I am currently having to do to make them switch places, using rows 5 and 15 as an example is: 1) cut/paste the info in row 5 into an empty row, then: 2) cut/paste in info in row 15 into row 5, then 3) Cut/paste the info in row 5 into row 15

I know it doesn't sound like too much hassle, but after doing this many times over many different documents the time it's taking is starting to add up!

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-28 21:22:04.431126

3 Answers

Sort by » oldest newest most voted

answered 2017-04-01 07:37:44 +0100

pierre-yves samyn gravatar image

updated 2017-04-01 07:39:09 +0100


It is possible to move one row (column) between two others in one step (and thus you can avoid one step & copy-paste).

  • Click on the header then on a cell in the row, keep the mouse button pressed,
  • Drag to the target, press and hold down the Alt key, release the left click.

Very short video on French TDF playlist.


edit flag offensive delete link more


Merci, Pierre! A very useful tidbit indeed, and one that I was not previously aware of.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-04-02 17:09:16 +0100 )edit

answered 2017-04-01 10:29:13 +0100

karolus gravatar image


  1. ctrl+x on row 5
  2. drag&drop 15 → 5
  3. ctrl+v on cell A15
edit flag offensive delete link more

answered 2017-04-01 13:01:50 +0100

Lupp gravatar image

updated 2017-04-01 13:02:06 +0100

If this is a reoccurring necessity:
1) Dedicate one or more columns for sorting keys, each one matching one of the reoccurring desiderations.
2) Edit the content of these columns as needed if changes are to make. (Formulas also allowed!)
3) Sort by the currently applicable column using the tool 'Data'>'Sort'.
4) Often same columns are useful for filtering "on the fly".

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-04-01 04:53:10 +0100

Seen: 4,999 times

Last updated: Apr 01 '17