7.20.2010

hyperlink formulas in excel

to add a hyperlink formula in excel:
=HYPERLINK("#sheetname!"&CELL("address",A999))
 
where 'sheetname' is the name of the worksheet and
'A999' is the the cell to link to
 
the pound sign, # is _Necessary_