Page 296 - Excel Workbook for Dummies

30_798452 ch21.qxp 3/13/06 8:40 PM Page 279
Chapter 21: Adding Hyperlinks to Spreadsheets 279
Editing Hyperlinks

Excel makes it easy to edit any hyperlink that you’ve added to your spreadsheet. 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 click and hold
down the mouse button rather than just click the link’s hypertext or graphic or, better
yet, to right-click the text or graphic to select the link when you want to edit.
(Remember that simply clicking only results 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, you click Edit Hyperlink on this shortcut menu. Doing
this opens the Edit Hyperlink dialog box 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.

Q. How do I delete a link without deleting the A. Selecting the Remove Hyperlink item on
graphic object or the contents of the cell to the object’s or cell’s shortcut menu rather
which the link is attached? than pressing the Delete key gets rid of the
link without affecting the graphic, cell con-
tents, or formatting.

Q. I’ve noticed in the worksheet that Excel change the Font settings for the Hyperlink
and Followed Hyperlink styles. To do this,
automatically displays hypertext (that is,
open the Style dialog box (Format➪Style).
text in a cell to which a hyperlink is
Select Hyperlink and Followed Hyperlink in
attached) in blue underlining that immedi-
the Style Name combo boxes and then
ately changes to purple underlining after I
click the Modify button. Doing this opens a
click the link. Is there any way to change
Format Cells dialog box with a Font tab
this default hypertext formatting?
where you can select any type of format-
A. Yes, but in order to change the appearance ting you want for the hypertext in your
worksheet.
of hypertext in the worksheet, you must
Assigning Links to Toolbars and Menus
Instead of assigning links to text cell entries in the worksheet to graphic objects that
you’ve added, you can assign the links to custom buttons or custom menu items that
you add to new or existing toolbars or pull-down menus in Excel. You can then activate
the links either by clicking their buttons on the custom toolbar or selecting their items
on the custom menus.

Try It

Exercise 21-4: Assigning Hyperlinks to Custom Menus and Toolbars
Open the workbook Solved21-3.xls you created in Exercise 21-3 and saved in your
Chapter 21 folder in the My Practice Spreadsheets folder on your hard disk. You will use
this workbook containing the links to the Mind Over Media trademark graphic and the
Greg’s e-mail hypertext to create custom menu items for the Help pull-down menu and a
custom toolbar containing the same links that you can then use in an Excel workbook: