Switch rows? (Calc)

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!

1 Like


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.


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


  1. ctrl+x on row 5
  2. drag&drop 15 → 5
  3. ctrl+v on cell A15

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