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
|