Remember Me?

#1
January 3rd 05, 10:57 PM
 Posts: n/a
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
January 4th 05, 02:08 PM
 JE McGimpsey Posts: n/a

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 ,
[email protected] 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?

#3
January 5th 05, 12:00 AM
 Dave Peterson Posts: n/a

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 ,
[email protected] 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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Hari Excel Discussion (Misc queries) 4 January 3rd 05 07:05 PM Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM John Links and Linking in Excel 3 December 3rd 04 07:29 PM

All times are GMT +1. The time now is 12:49 AM.