The user can use the mouse to select a cell or block of cells and move them to a new location. Move the mouse pointer to the edge of a selected column, row, or block of cells and then click and drag the selected range to the new location.

The following image displays a selected block of cells with the drag icon:

Move the block to the new location.

Release the mouse to display the data in the new location.

You can select and drag multiple contiguous columns or rows.

You can prevent or allow the user to drag and move with the CanUserDragDrop property in code.

Using Code

The following example allows the user to drag and move cells.

gcSpreadSheet1.CanUserDragDrop = true;

GcSpreadSheet1.CanUserDragDrop = True