drag and copy functionality

Hi,

How can i implement functionality like excel sheet-when we drag the mouse over cells then value of one cell gets copied to other cells.
Apart from this how can i select multiple cells and copy the values to other cells.
Please help me.

Thanks in advance.