Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to rearrange rows with the mouse in Calc.

In Excel, I select the whole row, then drag and drop it while holding Shift. This causes the drag and drop cursor to turn into a bar rather than cells, and the cells are inserted at the bar's position.

Is there a way to accomplish the same sort of thing in Calc without going around the houses inserting columns before the drag operation?

share|improve this question

Yes, there is a way to move whole columns using the mouse like in Excel:

  • To move: press ALT, then left click somewhere in the selected column (not the column header) and drag.

  • To copy: press Ctrl + ALT, then left click somewhere in the selected column (not the column header) and drag.


Tested with OpenOffice 3.2 Calc, Windows XP.

share|improve this answer
    
Aha, that does insert rather than replace, thanks! But maybe there's a bug on OS X, as the original is left behind. – joachim Mar 28 '10 at 10:59
1  
Worked for me - at least with the NeoOffice variant of OO. Opt-dragging dropped a copy of the source column and Ctrl-Opt-drag moved the column. – JRobert Jun 4 '10 at 11:43

As @Peter said, for moving columns you have to left click somewhere in the selected column (not on the column header) and drag. Now you can press some modifier keys:

  • no modifiers: move columns, overwriting the destination
  • Ctrl: copy columns, overwriting the destination
  • Alt: move columns, inserting them between other columns
  • Ctrl + Alt: copy columns, inserting them between other columns

Tested with OpenOffice.org 4.0.1 on Windows 7.

share|improve this answer
1  
Just downloaded the latest version today, and using Alt still copies rather than moves. I'm on OS X. – joachim Feb 13 '14 at 15:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .