Cell HyperLinks

  • Thread starter Thread starter June
  • Start date Start date
J

June

Could somebody please advise me as to how to link cells
from different sheets in the same workbook.
 
June, here's the easiest way I know:

1-Select a cell
2-Type =
3-Switch to another worksheet
4-Click a cell
5-Press Enter

That creates a link between the two. If you look at the cell where you
started, you'll see something like this: =Sheet2!C25. This says that
whatever value is in C25 on Sheet2 also appears here. Change the value in
the other cell, it changes here.

You can also create a link between two cells by typing the formula
(=Sheet2!C25 in our example) and pressing Enter, if you can remember the
syntax (which I never can, which is why I always do it by "pointing and
clicking," as in Steps 1-5 above).

Hope this helps. Post back with questions.
 
Third method which I find easiest if doing multiple contiguous cells.

Copy the cells and switch to sheet2 and Paste Special>Paste Link>OK>Esc

Gord Dibben Excel MVP
 
One thing to consider when linking cells from worksheet to
worksheet is naming. Using the naming box in the top left
corner of your worksheet as well as the worksheet name
itself can make linking cells or sets of cells in a
workbook easier. Simply typing =(sheet2!C6)will always
give you the value in cell C6 on workdsheet 2. If you were
to change the name of cell C6 to say SalesTotal then your
cell would read =SalesTotal. This saves you the time of
finding the cell reference. You can also highlight a
section of cells and give them a name as well. I hope this
helps.
 
Back
Top