Hyperlinks

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
 
A

Andy Brown

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.
 

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

Can UDF return a customized hyperlink? 3
Hyperlink to cell within a sheet breaks when cells are sorted 1
Using a hyperlink within a worksheet 2
Hyperlinks 2
HYPERLINK Worksheet Function 3
Hyperlinking from data in one sheet to matching data in another sheet 6
Convert hyperlink function into hyperlink 4
VLOOKUP return cell location and hyperlink 0

Top