O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Hyperlinks

Web browsers aren't the only programs that use hyperlinks— the underlined pieces of text that let you easily travel around the Web. In fact browsers weren't even the first. (Most believe that honor goes to the ambitious, 1960s-era cataloging project called Xanadu, which was never finished.) You might be surprised to find out that hyperlinks are quite useful in Excel, letting you link together different types of content and even navigate large spreadsheets. Here are three common examples:

  • You can create a hyperlink to a Web page. In this case, Excel opens your Web browser in a new window and points it to the appropriate page.

  • You can create a hyperlink to a different type of file. For example, you can link to a Word document or a PowerPoint presentation. In this case, Excel opens whatever program is registered on your computer to handle this type of file. For example, if you have a link to a .doc file and you have Word installed, Excel opens a new Word window to display the document.

  • You can create a hyperlink to another worksheet or another part of the current worksheet. This technique is helpful if you have a large amount of data, and you want the people using your workbook to be able to quickly jump to the important places.

In Excel, you can place a maximum of one hyperlink in each cell.

Tip

Excel can create Web page hyperlinks automatically. If you type some text that clearly corresponds to a Web address (for example, text that starts with "http://"), Excel converts ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required