View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Andrey Kazak Andrey Kazak is offline
external usenet poster
 
Posts: 4
Default 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...