Increase group of numbers by same amount
If you want to increase all of the cells in your range by two for instance,
then in a empty cell enter two (2), right click and copy it. Then highlight
your range, in this case C7:L25, right click within the range, select Paste
Special, check 'Add' and click 'OK'
Don't forget to delete the '2' in the previously empty cell,
Regards,
Alan.
"Chrissy" wrote in message
...
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!!
|