In OpenOffice Calc, how do I drag and drop cells to insert rather than replace their destination?
- by joachim
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?