Easiest way to create a link?

I'm just creating a simple link by typing the following:

='Sub Contracting'!F10

in the obvious format of

='worksheetName'!cell

What's the fastest and easiest way to do this in excel? Currently, I
have to type everything and it can be annoying flipping back and forth
etc. It seems that there should be some sort of intellisense or
something that would fill in the formula automatically for me or
perhaps a way I can click "Create Link" then click on the cell on
another worksheet to link to it.


--
ParaDiddle
------------------------------------------------------------------------
ParaDiddle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32886
View this thread: http://www.excelforum.com/showthread.php?threadid=526910

ParaDiddle
Mon Mar 27 17:48:09 CST 2006


Thanks... Paste Special works perfect and no typos!


--
ParaDiddle
------------------------------------------------------------------------
ParaDiddle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32886
View this thread: http://www.excelforum.com/showthread.php?threadid=526910

Peo
Mon Mar 27 17:22:18 CST 2006

How about copying and paste special as link?


--

Regards,

Peo Sjoblom


"ParaDiddle" <ParaDiddle.25cpmy_1143501300.3248@excelforum-nospam.com> wrote
in message news:ParaDiddle.25cpmy_1143501300.3248@excelforum-nospam.com...
>
> I'm just creating a simple link by typing the following:
>
> ='Sub Contracting'!F10
>
> in the obvious format of
>
> ='worksheetName'!cell
>
> What's the fastest and easiest way to do this in excel? Currently, I
> have to type everything and it can be annoying flipping back and forth
> etc. It seems that there should be some sort of intellisense or
> something that would fill in the formula automatically for me or
> perhaps a way I can click "Create Link" then click on the cell on
> another worksheet to link to it.
>
>
> --
> ParaDiddle
> ------------------------------------------------------------------------
> ParaDiddle's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=32886
> View this thread: http://www.excelforum.com/showthread.php?threadid=526910
>

Dave
Mon Mar 27 17:20:46 CST 2006

I like to type the equal sign, then use the mouse to go to the other sheet and
select that cell. Then hit enter.

But you could select the "sending" cell.
Edit|Copy
select the "receiving" cell
edit|paste special|click paste link

ParaDiddle wrote:
>
> I'm just creating a simple link by typing the following:
>
> ='Sub Contracting'!F10
>
> in the obvious format of
>
> ='worksheetName'!cell
>
> What's the fastest and easiest way to do this in excel? Currently, I
> have to type everything and it can be annoying flipping back and forth
> etc. It seems that there should be some sort of intellisense or
> something that would fill in the formula automatically for me or
> perhaps a way I can click "Create Link" then click on the cell on
> another worksheet to link to it.
>
> --
> ParaDiddle
> ------------------------------------------------------------------------
> ParaDiddle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32886
> View this thread: http://www.excelforum.com/showthread.php?threadid=526910

--

Dave Peterson