Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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!