Topic: Hyperlinks

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Activating a Hyperlink There are a few ways to activate a hyperlink in Excel listed here. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Adding a ScreenTip When you visit a Web site in your browser and you roll your mouse over a hyperlink, you may see a small pop-up tip concerning the link under the mouse. In Excel this is called a ScreenTip, and it is easy to add them to the hyperlinks in your workbook. Microsoft Excel versions: 2000 | 2002 | 2003

Changing Portions of Many Hyperlinks If you need to modify the URL used in a large number of hyperlinks, you can do so by using a macro and a little ingenuity. This tip shows how easy it is to get the changes you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Converting a Range of URLs to Hyperlinks When you enter a URL into a cell of your worksheet and press Enter, Excel normally recognizes it as a URL and automatically converts it to a hyperlink. If you have a whole series of non-linked, plain-text URLS in a worksheet, converting them all to hyperlinks can be a tedious task—if you don’t use a macro. This tip shows how easy it is to do the conversion once you create the right tool. Microsoft Excel versions: 2000 | 2002 | 2003

Converting to Hyperlinks in a Shared Workbook When you enter a URL or e-mail address in a worksheet, Excel usually converts it to a clickable hyperlink. This doesn’t occur, however, if the workbook is shared; the URL or address remains regular text. This tip discusses ways you can get around this behavior so that you have clickable hyperlinks in shared workbooks. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Deleting a Hyperlink Once a hyperlink has been placed in a workbook, it can be perplexing to figure out how to remove it. The process is easy, once you learn it, but can vary based on the version of Excel you are using. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Dynamic Hyperlinks in Excel Hyperlinks to many types of Web sites rely on passing parameters in the URL. Knowing this, you can construct a dynamic hyperlink by pulling information from various cells in your worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Editing a Hyperlink Got a hyperlink in a worksheet you need to change? It’s easier than you think, if you utilize the Edit Hyperlink dialog box. This tip explains the different ways you can display the dialog box and what you do once it is displayed. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Extracting URLs from Hyperlinked Images Pasting information from a Web page into an Excel worksheet may result in hyperlinked images being placed in that worksheet. If you want to extract the URLs from those hyperlinks, you will need to use a macro. This tip describes how to set up such an extraction macro. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Getting Rid of All Hyperlinks Tired of worksheets peppered with all sorts of hyperlinks. You can use an easy single-line macro to get rid of all hyperlinks at once. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Getting Rid of Many Hyperlinks Got a bunch of hyperlinks you need to get rid of? Here’s a handy (and simple) macro that can do the task for you. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Hyperlinks in Shared Workbooks Sharing workbooks can be a great way for multiple people to safely share the same data. Unfortunately, some Excel features (such as adding a hyperlink) are not available when a workbook is shared. This tip explains how to add the desired hyperlink to the workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Hyperlinks to Charts You can create hyperlinks to all sorts of worksheets in a workbook, but you cannot create a hyperlink to a chart sheet. This tip provides a workaround that should display just what you want hyperlinked in the first place. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Inserting Hyperlinks One type of data that Excel can store within a cell is a hyperlink to another resource either on your local computer or on the Web. This tip walks you through the steps you follow to insert just the type of hyperlink you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Jumping to Text in Worksheet from an Index Want to jump right to a single piece of data from an index you develop on a worksheet? It’s easy to do if you use the hyperlink method described in this tip. Microsoft Excel versions: 2000 | 2002 | 2003

Links to Hyperlinks If you create a link to a hyperlink, where both the link and the hyperlink are in different workbooks, you may wonder how to make the link behave just like the hyperlink it references. This can be done, but only if very specific criteria are met. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Opening an HTML Page in Excel Excel is a Web-aware application that allows you to access Internet information from within a worksheet. If you want to display a Web page from within a macro, however, Excel isn’t quite as friendly. The techniques covered in this tip will help you display the Web page just as you want. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Pasting a Hyperlink When you copy information from one workbook to another, you may want to link that information as a hyperlink. You can quickly achieve this goal by using the steps presented in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Putting More than One Hyperlink in a Cell Excel allows you to put a single hyperlink in a cell. If you have a need to put multiple hyperlinks in a cell, then you need to enlist the capabilities of programs other than Excel. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Removing Hyperlinks without a Macro If you have a whole slew of hyperlinks in a worksheet and you want to get rid of them, it’s easier than you think. This approach uses the Paste Special capabilities of Excel to get rid of the unwanted links. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Removing Hyperlinks without a Macro, Take Two Got a worksheet containing several hyperlinks you want to delete? There’s no need to resort to a macro (or even using the mouse) if you follow the simple series of steps in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

ScreenTip for an Image You can configure images in Excel so that if someone clicks on them, a macro is executed. You cannot, however, have a macro and a traditional ScreenTip tied to the same object. This tip explains how you can get around this limitation using two separate techniques. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Special Characters In Hyperlinks The typical way of creating a hyperlink is to use the Insert Hyperlink tool. Doing so, while easy, can limit what characters you can use in the link. This tip describes how to get around one such limitation. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Turning Off Hyperlink Activation Enter an e-mail address or URL into a cell, and Excel helpfully converts it to a clickable hyperlink. How you control this feature, first added in Excel 2000, depends on which version of Excel you are using. Microsoft Excel versions: 2000 | 2002 | 2003

Unwanted Hyperlinks Enter a URL or an e-mail address into a cell, and Excel helpfully converts it into a hyperlink that you can click to activate. If you don’t want this to occur, there are several approaches you can take, as described in this tip. Microsoft Excel versions: 2000 | 2002 | 2003

Using Drag-and-Drop to Create a Hyperlink If you open workbooks in two instances of Excel, you can use drag-and-drop techniques to create hyperlinks from one workbook to another. This is a quick and easy way to link your data together. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tips, Tricks, and Answers

Save Time!

Helpful Links

Great Info!

RSS Feeds