HYPERLINK function does not make cell a link.
Submitted by Maurits Rijk
Excel 2000 (don't know about other versions) has an option to insert hyperlinks into a sheet. I especially like the option to insert a link to "Place in This Document" that allows quick navigation through complicated sheets.
Version: git master