View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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