Hyperlinks

Hyperlinks are the key to creating a great user interface and to providing an easy way to open other workbooks. A hyperlink appears as blue underlined text (similar to internet hyperlinks) and when selected, a file is opened. Hyperlinks can be used to open other Excel workbooks, or other files like Microsoft Word or web pages (your computer will open the necessary application). Hyperlinks are ideal to use when you need to distribute information over a network. Using Excel hyperlinks, you set up an index.xls page that has the look and feel of an internet web page. The user can point and click to the reports and information that is needed. To insert a hyperlink, select "Hyperlink" from the "Insert" menu.

In fact, I am such a big fan of this simple Excel feature, I wrote an article about it and it was published in the Journal of Accountancy.  It's called Financial Reports in a Snap, and is in part responsible for the beginning of our firm.  So, this piece has sentimental value around here, and you'll actually find a copy of it hanging in our conference room.  If you'd like to check it out, stop by anytime.

Here is a video we put together about hyperlinks: Excel Video: Hyperlinks

Hyperlinks