In OpenOffice Calc, how do I drag and drop cells to insert rather than replace their destination?

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?

Solution 1:

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.

Solution 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.