Ask Your Question
0

Switch rows? (Calc)

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

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 close merge delete

3 Answers

Sort by » oldest newest most voted
1

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

pierre-yves samyn gravatar image

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

Hi

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.

Regards

edit flag offensive delete link more

Comments

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 +0200 )edit
1

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

karolus gravatar image

MayBe:

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

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

Lupp gravatar image

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

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

Question Tools

1 follower

Stats

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

Seen: 2,238 times

Last updated: Apr 01 '17