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?
|