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.

 How do I link many cells to one particular cell?
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## How do I link many cells to one particular cell?

 Thread Tools Display Modes
#1
January 3rd 05, 09:57 PM
 [email protected] external usenet poster 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, 01:08 PM
 JE McGimpsey external usenet poster 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 4th 05, 11:00 PM
 Dave Peterson external usenet poster 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 Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Concatenate cells without specifying/writing cell address individually Hari Excel Discussion (Misc queries) 4 January 3rd 05 06:05 PM To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM I am trying to link based on a text value instead of cell position John Links and Linking in Excel 3 December 3rd 04 06:29 PM

All times are GMT +1. The time now is 03:37 PM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top