Easiest way to create a link?

P

ParaDiddle

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.
 
D

Dave Peterson

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
 
Top