For quick access to releated information in another file or webpage or cell in different worksheet, we can use Hyperlink in worksheet cell.
To create a hyperlink, execute the following steps.
1. On the Insert tab, click Hyperlink.
2. The 'Insert Hyperlink' dialog box appears.
Text to display: Write text to display on worksheet cell. For Example, "Click Here to open file". Browse through the folder to select required file. Click OK.
Result: Hyperlink is created in cell A1. When you rest the mouse cursor on Hyperlink, it will display screentip. By default screentip is address of selected file.
3. You can change the Screentip to display more relevant information. Press Ctrl+K (Shortcut to Hyperlink file) to open Edit Hyperlink dialog box. Click on Screentip and change text.
Result: Screen tip is changed and more relevant to linked file.
4. To create a link to a web page, type the Text to display, Address, and click OK.
Note: If you want to change the text appears when you hover the link, click Screen Tip
Place in this document
Type the Text to display cell reference and click OK.
Explore More, It's Amazing…
2,101 total views, 1 views today