View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Modify Excel Formula

Find an empty cell.
Put =$x$2 in that cell
Select that cell
edit|copy

Select the column of numbers
Edit|paste special|check multiply

Clean up that helper cell with =$x$2 in it.

sharonm wrote:

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.


--

Dave Peterson