Modify range of cells at once...
Yes. This is exacly what I want. But is there any way to do it without
utilizing of a spare cell?
"FSt1" wrote:
hi
not sure if i understand but if you want to add 2 to a number of cells in a
range (or mutiply, subtract, divide), enter a 2 (or whatever number you need)
into a cell off to the side and copy it. then use pasted specialAdd (or
mutiply, subtract, divide).
regards
FSt1
"Andrey Kazak" wrote:
Greetings, dear Experts!
I want to select range and run such Command/Tool that modifies current
values of the range by simple formula (+, -, *, /) and pastes result values
instead the original ones.
Is this possible by the standard means of Excel?
Thank you in advance for propmt reply...
|