» Fast Copying & Pasting in Adjacent Cells
Using the mouse
To copy quickly by double-clicking:
1. Select cell B1.
2. Place the mouse on the handle in the bottom right-hand corner of the cell.
3. Double-click when the mouse pointer changes into a plus symbol. Excel copies the constants or formulas in the cell down the length of column B.