Posts Tagged ‘copy formulas’

PC Tip of the Week: Microsoft Excel 2007

Thursday, August 26th, 2010

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.