Hyperlink Help Needed

  • Thread starter Thread starter mclassic
  • Start date Start date
M

mclassic

Can anyone help me with this: I am creating an excell file with two
sheets. Cell "A1" on shhet1 is being hyperlinked to cell "F26" on
"sheet2". Now when I add a raw to "sheet2" my cell of interest on
sheet two becomes "F27" which no longer is linked to "sheet1" "A". Now
I am linked to new "F26" which is empty.
Can some one help me to keep the link beetween the value on original
"F26" on sheet2 and "A1" on sheet1 despite adding raws or columns to
sheet2 and moving my value to a different cell?

thanks
 
If you name your cell, when you create a hyperlink you will see the name
under defined names, it will always link to that cell. Let me know if i
misunderstood
 
This can be a problem using hyperlinks to navagate within a workbook.
because the links are normally enclosed in double-quotes, they don't adjust
as rows/columns/ are added/deleted. But here is a neat trick using the
HYPERLINK function:


A formula like:


=HYPERLINK("#Sheet2!F26","go")


will "lock" in place, but:


=HYPERLINK("#"&CELL("address",Sheet@!F26),"target")


will adjust !
 
Hi,

Do the following:

1. In the Sheet2 click cell F26.
2. On the Insert menu, point to Name, and then click define. The Define name
dialog box is displayed. In the Refer to text box, you find the reference as
=sheet2!$f$26.
3. In the Name in workbook text box, enter a name (for example, cs) for the
cell address.
4. Click Add.
5. The name “cs†is displayed in the Name in workbook list.
6. Click OK to save the settings and return to the Sheet2
7. Click Sheet1 tab and select the cell A1.
8. On the Insert menu, click Hyperlink. The Hyperlink dialog box Is displayed.
9. In the Link to , select Place in this document.
10. Under Or select a place in this document list, select the name under the
Defined Names.
11. Click Ok to return to Sheet1. Now when you click A1, you jump to cell
F26 of Sheet2.

Challa Prabhu
 
Back
Top