Using cell refs in Excel hyperlinks.

  • Thread starter Thread starter Piker
  • Start date Start date
Piker

It is always helpful to state which version of Excel you are using.

Excel 2002......

Right-click on a cell and select "Hyperlink".

Select from left "Place in this Document". From the list of worksheets pick
the sheet and enter a cellref or choose named range and OK.


Excel 97..............

Right-click on a cell and select "Edit Hyperlink".

"Link to File or URL" browse to your workbook(file) and select>OK.

"Named Location in File" browse to your sheet and enter a cellref or named
range and select>OK.

Have never used Excel 2000 so no info on that version.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
You must log in or register to reply here.

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

Macro to change formula? 5
Open specific hyperlink (accept) automatically in email with outlook 0
Hyperlinks changed by Excel again! 5
Activating hyperlinks 3
link two spreadsheets and copy cell ref accross row 2
Insert a hyperlink as the text in the cell? 2
GETPIVOTDATA #REF! error XL2003/2010 1
View Hyperlink in another cell 1

Back
Top