Easiest way to create a link?

  • Thread starter Thread starter ParaDiddle
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to create a link to a link in Excel (2007) 3
Paste link only - not value 4
how to create a URL in an Excel? 1
Faster way of linking multiple cells between spreadsheets? 1
double click through to link 2
What's the easiest way to add a character to the beginning of all cells? 1
How to create absolute link to cell in another workbook (Excel 2003) 1
VBA to move from one cell to another cell 6

Back
Top