At 02:21 29/06/2009 -0400, Jason Cipriani wrote:
All of the documentation for Calc seems to imply that all it takes
to move cells is to drag and drop them with the mouse. However,
this does not appear to be true. Dragging and dropping with the
mouse in Calc only selects cells / modifies the selection. :-S
You do need to select the cell range first and then drag it as a
separate operation.
How do I move cells with the mouse in Calc?
o Select the range: either click at one corner of the range and then
shift-click at the opposite corner, or else just drag the mouse over the range.
o After releasing the mouse for an instant, then drag the range
where you want it.
o To copy instead of moving, drag first and then hold down Ctrl
whilst releasing the mouse.
If you want to select a single cell, you cannot just drag over it, of
course, so there has to be another technique. In fact, there are two: either
o click the cell and then shift-click the same cell (that's rather
like the earlier scheme), or
o click the cell and drag into a neighbouring cell and back into the
original cell. (Again, now release the mouse before attempting to
drag the data.)
Also, the documentation should probably be updated with the secret technique.
All of this is described in the help text under "selecting;cells" and
"moving;cells by drag and drop".
Also, a more specific question: Is there a way to either rearrange
the rows in a Calc spreadsheet (i.e. pick one and move it elsewhere)
or swap two rows?
Yes.
o Select the relevant row or rows (by clicking and shift-clicking
the row labels).
o Drag the rows to the new position.
o Hold down Alt whilst releasing the mouse.
Note that, if you are moving rows downward, the rows surrounding the
new position will be moved up as a result of the move. So you need
to (Alt-)drop the moving rows in the position you need by reference
to the surrounding data, not the row number: this can be
confusing. If you want to swap rows five and six, for example, you
need to drag row five down to row seven before (Alt-)dropping it -
below the data in row six, that it. Alternatively, you can just drag
row six up to row five. Try it out and you will soon see the idea.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
