How do I drag a formula so 1 variable changes and 1 stays on a cel

K

keithpt

I want to make a formula that when dragged will have one variable that will
change as it comes down the page and one that will stay constantly refering
to a given cell.
 
F

Fred Smith

You want an absolute address. Precede the cell you want to stay constant
with a $ sign. That tells Excel not to change it. Or, if you want, F4 will
do it for you.
 
Top