Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
enter =$D$4 in one cell and copy it to the rest. The $ keeps the address
from changing relatively. |
#3
|
|||
|
|||
Are the cells on the same worksheet?
If yes, you could select all the cells that should get that formula and type this: =$d$4 but hit control enter to populate all the cells in the selection. (the $'s keep excel from adjusting the address for each cell) If D4 can be empty, you may want a formula like: =if($d$4="","",$d$4) (If d4 is empty, then =d4 will return a 0.) justinfishman22 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
I am trying to link based on a text value instead of cell position | Links and Linking in Excel |