View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Adding a number to multiple cells at once

Enter 5 into any blank cell
Copy that cell
Select your range of numbers to multiply
From the Edit Menu, select "Paste Special..."
Check "Multiply" option
Click OK
Delete the 5 you entered originally

HTH,
Elkar


"SeveranceD" wrote:

Hi, I've got a problem that I just don't really know how to word right to
search for a solution to:

I've got a large spreadsheet with lots of number, not formulas, in the
cells. I need to multiply every number in the sheets by 5, but I have no
idea how to apply that to cells. How would I go about adding/multiplying
numbers in a range of cells?

Thanks