How to Specify That the Cell Address Will Not Change in Excel

1. Select the cell that contains the formula you want to change. Place the cursor in the formula bar, located directly above the spreadsheet, in order to alter the formula.
2. Insert a dollar sign, '$,' in front of the reference's column or row in order to make it an absolute reference. For example, you can enter '$A1,' 'A$1' or '$A$1.' Only the part of the reference with the dollar sign in front of it becomes absolute. '$A1' will always reference column A, but the row will change if the formula moves.
3. Press 'Enter' or select another cell on the worksheet to complete the changes to the formula.