Press the F4 key to make that cell reference absolute. Continue to press F4 to have Excel cycle through the different reference types. Click the Enter to calculate