G Guest Jun 7, 2004 #1 how do i create a formula using the same cell reference (locking that cell) to be calulated in all formulas using fill down short cut?
how do i create a formula using the same cell reference (locking that cell) to be calulated in all formulas using fill down short cut?
N Norman Harker Jun 7, 2004 #2 Hi John! Reference the cell (eg) $A$1 See: Chip Pearson http://www.cpearson.com/excel/relative.htm
