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

[ojalaquellueva]

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!

[robleyd]

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.