Copying both formulas and constants

[Quimper]

I have relative formulas in C1, D1, and F1. E1 contains a constant which is $500.00. When I select C1:F1 and drag the handle down, the formulas in C2, D2, F2 copy perfectly with relative references. But E2 has $501.00 and not $500.00. LIkewise, if I drag the handle to copy dozens of rows, the formulas each copy correctly with relative references, but E3 has $502.00, E4 has $503.00, etc. How do I get the constant to always be copied as $500.00? I'm using Excel 2007.

 

[pagrender]

Can you put a formula in E2 to say =E1 and copy that down? Then they will all be the same value.