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
|