How do I lock a cell reference in the formula that I'm dragging to other rows.
A abcdbaker Nov 24, 2005 #1 How do I lock a cell reference in the formula that I'm dragging to other rows.
R Rowan Drummond Nov 24, 2005 #2 Use $ signs eg = $A$1. See help on absolute versus relative references. Hope this helps Rowan
M Max Nov 24, 2005 #4 Put a dollar sign ($) in front of the col &/or row reference e.g.: $A$1: locks the point to both col & row ref of the cell A1 $A1: locks the point only to the col ref: "A" of the cell A1 A$1: locks the point only to the row ref: "1" of the cell A1 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- abcdbaker said: How do I lock a cell reference in the formula that I'm dragging to other Click to expand... rows.
Put a dollar sign ($) in front of the col &/or row reference e.g.: $A$1: locks the point to both col & row ref of the cell A1 $A1: locks the point only to the col ref: "A" of the cell A1 A$1: locks the point only to the row ref: "1" of the cell A1 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- abcdbaker said: How do I lock a cell reference in the formula that I'm dragging to other Click to expand... rows.
