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!