Excel formula copied down
 

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!

=F3*A$2

--
Ian
--
"Pat" wrote in message
...
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!

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

"Pat" wrote:

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!

Thanks So Much!



"Steve Boxler" wrote:

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

"Pat" wrote:

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!

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
--
Earl Kiosterud
www.smokeylake.com

"Pat" wrote in message
...
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!