Hyperlinks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On Inserting a hyperlink in Excel 2000.
Example - Want to set up an hyperlink in SHEET 1 cell A1 to go to say SHEET 2 cell B10.
How do I insert hyperlink and get the link to move with the target cell if lines are inserted before line 10 in SHHET 2?

Cheers
 
Create a defined name for the "go to" cell (select the cell, type eg:
"Dest"* in the Name Box**, press Enter.

Then use the Defined Names option in the Insert HyperLink dialog.

Rgds,
Andy

* without the quotes

** the dropdown to the left of the formula bar that normally shows the
address of the current active cell.
 
Back
Top