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

460 Hyperlinks 101
Editing hyperlinks
Excel makes it easy to edit any hyperlink that you’ve added to your spread- sheet. The only trick to editing a link is that you have to be careful not
to activate the link during the editing process. This means that you must always remember to right-click the link’s hypertext or graphic to select the link that you want to edit because clicking results only in activating the link.
When you right-click a link, Excel displays its shortcut menu. If you want to modify the link’s destination or ScreenTip, click Edit Hyperlink on this short- cut menu. This action opens the Edit Hyperlink dialog box with the same options as the Insert Hyperlink dialog box (shown previously in Figure 2-1). You can then use the Link To buttons on the left side of the dialog box to modify the link’s destination or the ScreenTip button to add or change the ScreenTip text.
Removing a hyperlink
If you want to remove the hyperlink from a cell entry or graphic object with- out getting rid of the text entry or the graphic, right-click the cell or graphic and then click the Remove Hyperlink item on the cell’s or object’s shortcut menu.
If you want to clear the cell of both its link and text entry, click the Delete item on the cell’s shortcut menu. To get rid of a graphic object along with its hyperlink, right-click the object (this action opens its shortcut menu) and then immediately click the object to remove the shortcut menu without either deselecting the graphic or activating the hyperlink. At this point, you can press the Delete key to delete both the graphic and the associated link.
Copying and moving a hyperlink
When you need to copy or move a hyperlink to a new place in the work- sheet, you can use either the drag-and-drop or the cut-and-paste method. Again, the main challenge to using either method is selecting the link with- out activating it because clicking the cell or graphic object containing the link results in catapulting you over to the link’s destination point.
To select a cell that contains hypertext, use the arrow keys to position the cell cursor in that cell or use the Go To feature (F5 or Ctrl+G) and enter
the cell’s address in the Go To dialog box to move the cell cursor there. To select a graphic object that contains a hyperlink, right-click the graphic to select it as well as to display its shortcut menu, and then immediately click the graphic (with the left mouse button) to remove the shortcut menu while keeping the object selected.