Applying a formula to multiple cells
 

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?

Applying a formula to multiple cells
 

Put 10% in cell A1

formula then =sum(b1*$A$1) copy as needed

"Lindsay" wrote:

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?

Applying a formula to multiple cells
 

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.

Lindsay wrote:

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?

--

Dave Peterson