If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do you add a constant number to an array (paste special)
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. |
#2
|
|||
|
|||
how do you add a constant number to an array (paste special)
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. kc wrote: 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. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|