Page 475 - Excel 2013 All-in-One For Dummies

The Insert Hyperlink dialog box opens (similar to the one shown in Figure 2-1). If you selected a graphic object or a cell that contains some entry besides text before opening this dialog box, you notice that the Text to Display text box contains <<Selection in Document>> and that
this box is grayed out (because there isn’t any text to edit when anchor- ing a link to a graphic). If you selected a cell with a text entry, that entry appears in the Text to Display text box. You can edit this text in this box; however, be aware that any change that you make to it here is reflected in the current cell when you close the Insert Hyperlink dialog box.
Hyperlinks 101 457
Figure 2-1:
Creating
a new hyperlink in the Insert Hyperlink dialog box.
The ScreenTip button located to the immediate right of the Text to Display text box enables you to add text describing the function of the link when you position the mouse pointer over the cell or graphic object to which the link is attached. To add a ScreenTip for your link, follow Step 3. Note that if you don’t add your own ScreenTip, Excel automati- cally creates its own ScreenTip that lists the destination of the new link when you position the mouse pointer on its anchor.
3. (Optional) Click the ScreenTip button and then type the text that you want to appear next to the mouse pointer in the Set Hyperlink ScreenTip dialog box before you click OK.
By default, Excel selects the Existing File or Web Page button in the Link To area on the left side of the Insert Hyperlink dialog box, thus enabling you to assign the link destination to a file on your hard drive or to a web page. To link to a cell or cell range in the current workbook, click the Place in This Document button. To link to a new document, click the Create New Document button. To link to a new e-mail message, click the E-Mail Address button.
4. Select the type of destination for the new link by clicking its button in the Link To panel on the left side of the Insert Hyperlink dialog box.
Book IV Chapter 2
Using Hyperlinks