How to Copy Formulas Without Changing Them in Excel

1. Open your Excel document.
2. Click on the cell containing the formula you wish to work on.
3. Locate your cell references in the formula shown in the Formula Bar. These will be a letter followed by a number, such as A3 or D14.
4. Place a dollar sign ($) in front of the letter and number of the cell reference you don't want to change. Examples would be $A$3 or $D$14.
5. Copy your formula to the other parts of your spreadsheet--you'll see that Excel does not change your cell references.