How to use one cell to autofill

[rphan]

Say I want to use cell c3 in a formula.

When I drag down it goes
Example
=D4+E4+C3
=D5+E5+C4
=D6+E6+C5

I want it to be
=D4+E4+C3
=D5+E5+C3
=D6+E6+C3

How do you get the formula to recognize that you always want it to be c3 when you drag down to fill in the rest of the boxes.

Thanks in Advance

-Rphan

[NBVC]

Try:

=D4+E4+C$3

The $ "freezes" the row number

[Barbara Excel]

Rphan

use an absolute reference for the cell reference you want to remain constant.

You can check out absolute and relative cell reference information here

Hope that helps

Barbara

http://www.howtoexcelatexcel.com