1. Link type. Select type of hyperlink.
2. Web address/E-mail address/Existing File/Cell reference or defined name. Type required information for the selected link type: web address, E-mail address, existing file path, range address or defined name in the current workbook.
3. Bookmark/Subject/Text to display. Enter required information for the selected link type. For web address a bookmark name linked to a section of the page can be entered. For E-mail address, subject and for a place in the current workbook, a range address or defined name.
4. Text to display. Type text to show in the current selected cell as link information. If no information is entered, the web/email address, file name, cell reference or defined name will be shown instead.
5. Screen tip. Type text that will be shown when hovering over the cell link.
Notes:
You must press ENTER after typing information in each text box to update the selected cell link.
Related topics:
How to set a defined name to identify a range.
|