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:
- cut/paste the info in row 5 into an empty row, then:
- cut/paste in info in row 15 into row 5, then
- 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!