Increase group of numbers by same amount
By "equally increase all the values", do you mean you want to increase
them by the same percentage (e.g. by 10%) or do you want to add the
same number (e.g. 5) to each of them?
If it is the first of these, then pick a blank cell somewhere and enter
1.1 in it (for 110%). If it is the second, then enter the number 5 into
the blank cell. Select the cell into which you have just entered the
number and click <copy, then highlight the cells C7 - L35 and click
Edit | Paste Special, and in the dialogue box you should EITHER check
Multiply (if you are using a percentage) OR Add (if you are adding a
fixed value) then click Values | OK followed by <Esc.
Hope this helps.
Pete
Chrissy wrote:
In my worksheet I have numbers in cells C7 - L35. Is there a way to equally
increase all the values (which are different) without re-keying each one by
hand? I don't know if I should be looking for a formula some sort of
formatting.
Help, please!!
|