2009/6/29 Jason Cipriani <[email protected]> > 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 > > How do I move cells with the mouse in Calc? Also, the documentation > should probably be updated with the secret technique.
Double click the first cell so that the cursor actually moves into the cell. Select the data. Hold down the Shift key and double click in the last cell of a contiguous (possibly multi-row and multi-column) range; select its data. Now you can drag that range to *move* it to where you want it. Weirdly, if the "range" is only a single cell - if you only selected one cell's data, the drag *copies* that data. I have no idea why; perhaps someone else can explain. > > 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? Not that I know of. > > > Thanks, > Jason > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Harold Fuchs London, England Please reply *only* to [email protected]
