How do I link many cells to one particular cell?
 

I am trying to link multiple cells to one particular cell and can't seem to
do it. I want the multiple cells not just to have the same information but
be connected to the same cell. I want multiple cells to take the information
from ex. cell D4. So everytime i change cell D4 every cell that is linked to
it changes. Do I have to input =D4 into every single cell that I want to
link or is there an easy way to mass link?

You have to enter =D4 in each cell. Select all the cells you want to
link, then type =D4 and hit CTRL-Enter to put the formula in each cell.

In article ,
fish@divi wrote:

I am trying to link multiple cells to one particular cell and can't seem to
do it. I want the multiple cells not just to have the same information but
be connected to the same cell. I want multiple cells to take the information
from ex. cell D4. So everytime i change cell D4 every cell that is linked to
it changes. Do I have to input =D4 into every single cell that I want to
link or is there an easy way to mass link?

I'm sure JE meant to write
=$d$4
if you select more than one cell.



JE McGimpsey wrote:

You have to enter =D4 in each cell. Select all the cells you want to
link, then type =D4 and hit CTRL-Enter to put the formula in each cell.

In article ,
fish@divi wrote:

I am trying to link multiple cells to one particular cell and can't seem to
do it. I want the multiple cells not just to have the same information but
be connected to the same cell. I want multiple cells to take the information
from ex. cell D4. So everytime i change cell D4 every cell that is linked to
it changes. Do I have to input =D4 into every single cell that I want to
link or is there an easy way to mass link?

--

Dave Peterson