Excel formula copied down

P

Pat

Is there a way to copy down a column this formula =F3*A2 and have the A2 stay
the same all the way down? The F3 would change on each row, F4, F5 etc. but
the A2 would stay 'constant'.

Thanks in advance for any help!
 
S

Steve Boxler

To keep part of a formula constant, precede the column or row number with the
dollar sign ($)
So if you want A2 referenced all of the way down, write it as $A$2
Also, if you want just the column to remain a constant and the row change,
write it as $A2
 
P

Pat

Thanks So Much!



Steve Boxler said:
To keep part of a formula constant, precede the column or row number with the
dollar sign ($)
So if you want A2 referenced all of the way down, write it as $A$2
Also, if you want just the column to remain a constant and the row change,
write it as $A2
Click to expand...
 
E

Earl Kiosterud

Pat,

You need to make A2 an absolute cell reference, $A$2. The quick way is to
click in the A2 (or next to it) in the formula bar, then press F4. That
will put in the $. Press Enter to finish the edit.

=F3*$A$2

Another, preferable, way, is to assign a range name to A2. Select it, click
in the name box (left of the formula bar), type in a name, like Tax_Rate,
press Enter. Now use:

=Tax_Rate * F3
 
Top