Use the Fill Handle to Copy Formulas

You can copy a formula or text to adjacent cells by clicking on the fill handle (the notch in the right-hand corner of a worksheet cell) with your left-mouse button and dragging either down or across. (Our thanks go to Kedar Desai, who got paid for submitting this tip!) For even more options, hold down the right-mouse button while you click and drag…when you release the mouse button, a shortcut menu will appear.