Other Links
This is one of the 33 lessons from the
Tutorial on Excel
Lesson 2-4: Hyperlinks in Excel
More and more Excel is used instead of Power Point to develop nice presentations. Using Excel for presentations adds credibility to your show it looks less like bells and whistles.
In this era of resource conservation you also need you to make your reports user friendly on screen.
Finally, a report that is well designed and easy to walk through will deserve more attention.
For these reasons hyperlinks become an interesting feature. Like when you are surfing the WWW, you click on a word, an image, a text box or anything else and you are taken somewhere else. This technology is called hyperlinks and it exists within Excel.
With these hyperlinks you can surf from one sheet of the workbook to the other, from one workbook to another (opened or not) and you can open any other file created with any other program (Word, Internet Explorer, etc.).
You can create hyperlinks in Excel and attach them to images, text boxes and any other objects. We strongly suggest that you never create hyperlinks attached to words and cells. They are a mess to manage.
Add text boxes, images or autoShapes in your sheets and attach hyperlinks to them. If you start using a lot of these gizmos make the "Drawing" toolbar visible in Excel. Go to "View/Toolbar/Drawing" . The tool bar will become visible at the bottom of you Excel screen. Click on "AutoShapes" and select one or click on the text box icon 
go to the sheet and stretch the item. See lesson 2-5 for more information on text boxes and other objects.
To create an hyperlink you select the object, you go to the hyperlink icon 
and follow the instructions.
You can even open your email program within Excel with an address and a subject already in place.
Using the hyperlinks you can insert a map of New-England on a worksheet and when you click on a State you are taken to the table and chart concerning that State. Your on screen presentation will impress. See "excel-example-imagemap.xls".
Yo can also use hyperlinks to access you other spreadsheets instead of going down a long list of directories and sub-directories in "My Computer" or "Widows Explorer" Download "0-switchboard-excel.xls" that gives you access to 24 other spreadsheets (tutorials, examples and case studies)
This is one of the 33 lessons from the
Tutorial on Excel