When I apply the formula to other cells G2 changes to G3,G4,G5 I want to remain the same. How can I do this? Thank you
2006-10-20 18:58:17 · 5 answers · asked by christoforoschris 1 in Computers & Internet ➔ Software
To lock the reference precede the row or column you want with a dollar sign ($). So if you want to lock the column but now row you would enter the formula like so: =(A1+B2)*$G2 if you want to lock the row and column it would look like this =(A1+B2)*$G$2
2006-10-20 20:00:13 · answer #1 · answered by Al 3 · 0⤊ 0⤋
A1+B2*$G$2
2006-10-21 02:00:43 · answer #2 · answered by TLWOLFf 4 · 0⤊ 0⤋
+A1+B2*$G$2, the dollar signs fix the reference point to cell G2
2006-10-21 02:05:33 · answer #3 · answered by Aurthor D 4 · 0⤊ 0⤋
=A1+B2*$G$2
The dollar signs give you a fixed cell. G2 will stay fixed no matter where you copy the formula.
2006-10-21 02:00:52 · answer #4 · answered by x 5 · 1⤊ 0⤋
Enter it as $g$2. That is the way to do an "absolute" reference, as opposed to a relative reference.
2006-10-21 02:00:48 · answer #5 · answered by Slake 3 · 1⤊ 0⤋