Applying a formula to multiple cells

L

Lindsay

I have numerical data in many cells and am needing to multiply all cells by
10%. Is there a way to apply a formula to many cells at once? Rather than
entering *.10 into every single cell?
 
D

Dave Peterson

Put .10 in an empty cell
edit|copy that cell

Select the range to adjust
edit|paste special|values and multiply

clean up that cell.
 
D

David Biddulph

Perhaps you could explain to us the difference you expect to see between
=sum(b1*$A$1) and =b1*$A$1 ?
But in any case, paste special multiply is probably the better answer.
 
Top