Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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 at 15:36

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.