Select the cell (or range) to copy, and Ctrl/C, then select the first
cell to be copied to, and hold the CTRL key to select other cells or
cell ranges.

Ctrl/V to complete the copy.

--

marat Wrote:
How can I drag value from A1 to B1, from A6 to B2, from A12 to
B3,....etc


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532876