Microsoft® Excel® 2010 Inside Out

Creating a Hyperlink in a Cell

You can create a hyperlink in a cell by clicking the Insert tab and then clicking Hyperlink. But if you’re linking to a Web site and you already know the site’s URL, you can type the URL directly in the cell. If the URL begins with www, Excel assumes it’s an HTTP (Web site) URL and creates a hyperlink for you. If the URL doesn’t begin with www, you need to include the prefix http://. (If the URL uses some other prefix, such as ftp://, you must, of course, type that.)

As mentioned, you can use the same technique to create a hyperlink to a network path. If the cell contents look like \\servername\sharename, Excel creates ...