» Fast Copying & Pasting in Adjacent Cells

CATEGORY - Excel Keyboard Shortcuts VERSION - All Microsoft Excel Versions

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.