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