Copy Formulas with the Fill Handle
1. Create the formula in the appropriate cell on the spreadsheet.
2. Click on that cell to make it the active cell.
3. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the active cell.
4. Drag the fill handle to copy the formula to as many cells as needed.