Page 477 - Excel 2013 All-in-One For Dummies
P. 477

As soon as you click OK, Excel closes the Insert Hyperlink dialog box and returns you to the worksheet with the new link (unless you specified that the new link is to create a new document and you left the Edit New Document Now option button selected, in which case, you’re in a new document — possibly in another application program such as Microsoft Word). If you anchored your new hyperlink to a graphic object, that object is still selected in the worksheet. (To deselect the object, click a cell outside its boundaries.) If you anchored your hyperlink to text in the current cell, the text now appears in blue and is underlined. (You may not be able to see the underlining until you move the cell cursor out of the cell.)
When you position the mouse pointer over the cell with the hypertext or the graphic object with the hyperlink, the mouse or Touch pointer changes from a thick, white cross to a hand with the index finger pointing upward. The ScreenTip that you assigned appears below and to the right of the hand mouse pointer.
If you didn’t assign your own ScreenTip to the hyperlink when creating it, Excel adds its own message that shows the URL destination of the link. If the link is a hypertext link (that is, if it’s anchored to a cell containing a text entry), the message in the ScreenTip also adds the following message:
Click once to follow. Click and hold to select this cell.
Follow that link!
To follow a hyperlink (assuming that your tablet or computer can connect to the Internet), click the link text or graphic object with the hand mouse or Touch pointer. Excel then takes you to the destination. If the destination is a cell in the workbook, Excel makes that cell current. If the destination is a cell range, Excel selects the range and makes the first cell of the range current.
If this destination is a document created with another application program, Excel launches the application program (assuming that it’s available on the current computer). If this destination is a web page on the World Wide Web, Excel launches your web browser, connects you to the Internet, and then opens the page in the browser.
After you follow a hypertext link to its destination, the color of its text changes from the traditional blue to a dark shade of purple (without affecting its underlining). This color change indicates that the hyperlink has been followed. (Note, however, that graphic hyperlinks don’t show any change in color after you follow them.) Followed hypertext links regain their original blue color when you reopen their workbooks in Excel.
Hyperlinks 101 459
  Book IV Chapter 2
 Using Hyperlinks
























































































   475   476   477   478   479