Editing Links in a Worksheet
The only trick to editing a link is that you have to be really careful not to activate the link during the editing process. You must always remember to Ctrl+click or right-click on the link's hypertext or graphic to select the link that you want to edit because simply clicking activates the link.
When you right-click a link, Excel displays its shortcut menu. If you want to modify the link's destination or ScreenTip, select the Edit Hyperlink option. The Edit Hyperlink dialog box opens with the same options as the Insert Hyperlink dialog box. 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.
If you want to remove the hyperlink from a cell entry or graphic object without getting rid of the text entry or the graphic, right-click on the cell or graphic and then select the Remove Hyperlink item. If you want to clear the cell of both its link and text entry, select the Delete item. To get rid of a graphic object along with its hyperlink, Ctrl+click the object and press the Delete key.