Hello,
I was not sure which Excel Group this should be asked in, so sorry if this
is the wrong one.

If I have a column of values, how can I create a formula in each cell to be
value * an absolute cell in the worksheet. For example I have:

345
367.45
241.67

I want to have:

=345 * $x$2
=367.45 * $x$2
=241.67 * $x$2

I want the formula in the cell when I am done which would refer to the same
cell (x2) as opposed to having just a total number. And I was hoping I could
do this without hitting F2 and editing each cell manually since my actual
column is much larger.

Any suggestions, would be greatly appreciated! Thanks in advance.