Ask Your Question
0

How do I move columns in a Calc sheet on a Mac?

asked 2017-04-28 23:10:20 +0200

ojalaquellueva gravatar image

updated 2017-04-28 23:13:34 +0200

What is the most efficient way to move one or more columns on a Calc sheet? So far, the best method I have come up with is as follows:

  1. Select column(s) to be moved
  2. Right click on selection & choose "Cut"
  3. Select column before which you wish to insert the columns
  4. Right click on selection & choose "Paste special..."
  5. In the popup, under "Shift cells", select "Right" & press "OK"
  6. Select the empty columns left behind by the columns you cut
  7. Right click on the selection & choose "Delete..."

Compare the above to the same operation in Excel:

  1. Select column(s) to be moved
  2. Right click on selection & choose "Cut"
  3. Select column before which you wish to insert the columns
  4. Right click on selection & choose "Insert cut cells"

The last step in Excel takes care of shifting right, pasting and deleting the old columns in a single operation. That's three fewer steps.

Is there any way to do this with the same efficiency in LibreOffice? I understand this may be possible in Windows, but so far I have found a way to do it on a Mac (OS 10.12.4) . Part of the problem is that cutting in LO (at least on a Mac) does not remove the cut cells but merely leaves them blank.

Thanks!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-04-29 01:08:12 +0200

robleyd gravatar image

updated 2017-04-29 01:10:18 +0200

Try this - works for me in AOO/Linux

Select the source column

Click again anywhere on the selected area, hold for a second and drag left or right.

To move the column, hold Alt when you release the mouse button to drop it.

Note:

Drop with no key pressed: move/replace

Drop with Ctrl: copy source to target

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-28 23:10:20 +0200

Seen: 1,005 times

Last updated: Apr 29 '17