Hyperlink to the sheets Jump to a document stored at the different location from within a document. Hyperlinks can be stored within your file as either relative or absolute
Types of hyperlink Absolute and relative hyperlink
Absolute hyperlink Stores complete path of file If file/target is removed absolute hyperlink will not work.
Relative hyperlink It contains partial address with respect to current location. Is only possible when both source and destination files are on the same location. Relative link will stop working only if the start and target locations change relative to each other .
Creating/inserting hyperlink Keep cursor in any cell Insert menu -> hyperlink or ctrl+k
Four categories of hyperlink Internet Mail and news Document New document
Further settings FRAME - HOW HYPERLINK WILL OPEN (WEB BROWSER) FORM – TEXT OR BUTTON ‘TEXT – LINK TEXT TO BE DISPLAYED , IF NOT FULL URL WILL BE DISPLAYED NAME – WORKS WITH HTML FILES ONLY