how do you add a constant number to an array (paste special)

K

kc

I am trying to link the contents of a group of cells and
add a constant number to them such as 0.375. I have only
been able to do this by copy and paste special- then after
it has pasted I add the 0.375 to the end of the link.
However, I am only able to do this one cell at a time or
it says I cannot change part of an array. Is there a way
to do this to multiple cells? Thank you.
 
D

Dave Peterson

If you're trying to just some of the cells in the array, then I don't think you
can.

But if you're trying to change all the cells in the array, couldn't you just the
array formula?

select the current array
Edit|Goto|Special|Current Array
(or ctrl-/ (control slash))

Then modify the formula and reenter it with ctrl-shift-enter.
 
Top