There are two ways of moving and copying cells in Gnumeric:
Using copy/cut/paste operations
Using the mouse to drag the selection
Gnumeric allows the user to move and copy cells and their contents by simply dragging and dropping the cell to its new location.
The basic procedure to quickly drag and drop a cell to a new location is to click on the border, and drag the cell to its new location and release. The contents of the cell will be moved to the new cell.
Click (MB1) on the border (anywhere, except the autofill square in the bottom right corner).Ctrl+MB1 copies the cell, why a plain click just moves the cell.
Drag the cell to the new cell location.
Release the selection.
This is the simplest method and most common use the drag and drop cell moving and copying. The key bindings give you a good set of options for quick moving and copying.
The other more extensive option to moving and copying cells is the right click options. This presents a menu of options that is more extensive that can be easily done with the normal key bindings
Right Click (MB3) on the border (anywhere, except the autofill square in the bottom right corner).
Drag the cell to the new cell location.
Release the selection. An options menu should pop-up.
Select the appropriate option from the menu and click again. The new cell should have the new info.
Copy: Same effect as the normal Copy operations. It copies the value, the format, and the formula. Equivalent to Ctrl+MB1.
Move: Same effect as the normal Move operations. It moves the value, the format, and the formula. Equivalent to MB1.
Copy Formats: Copies the formatting info of the source cell. This includes number format, color, font, fill type, etc.
Copy Values: Copies the value in the source cell to the destination cell.
Shift Cells Down and Copy: not implemented yet
Shift Cells Right and Copy: not implemented yet
Shift Cells Down and Move: not implemented yet
Shift Cells Right and Move: not implemen