Any MS Excel experts out there?

Question

Just a quickie...

I want to be able to anchor ONLY one row number in a copied (dragged) series of formulae. Specifically, I have the following...

Row 3 is

=(F3/F2*G2)

I want all subsequent rows to reference F<row number> but anchor F2 and G2.

e.g.

Row 4 =(F4/F2*G2)

Row 5 =(F5/F2*G2)

Row 6 =(F6/F2*G2)

.

.

.

Can anyone help - PLEASE?

Thanks.

Answer 1

garbo&#039;s answer is correct, but just to expand on it a bit.  The $ sign tells excel to lock/anchor that row/column reference and not change it as you copy/paste it elsewhere.  In spreadsheet terms, it makes it an &quot;absolute&quot; cell reference instead of a &quot;relative&quot; cell reference.

you can also anchor just the row or just the column

$A$1 means anchor the column and the row

$A1 means anchor the column only but let the row number change

A$1 means anchor the row only but let the column change

also when typing your formula, pressing &lt;F4&gt; will change the cell reference to an absolute reference.  Pressing it again changes it to column only. Pressing changes it to row only.  Pressing a 4th time removes the $ completely again.

Answer 2

The &#039;$&#039; symbol &#039;anchors&#039; the cell reference so it does not change when dragging a formula.  Thus your formulas should be entered as:

Row 4 =(F4/$F$2*$G$2)

Row 5 =(F5/$F$2*$G$2)

Row 6 =(F6/$F$2*$G$2)