Leading the way in Microsoft Office Development

What is a Hyperlink Base?

If you are going to include a lot of hyperlinks in your workbook and all the links are going to the same place you can avoid entering the path multiple times.

Using the Hyperlink base option you can define the path you want to use for all the hyperlinks you create in a workbook.

You can define your hyperlink base from the (File > Properties)(Summary tab) dialog box.

Define your Hyperlink Base

Lets suppose that I wanted to include links to several articles on the Microsoft Office Online website.

I know that all these URLs will have the same protocol, web address and path.

http://office.microsoft.com/en-us/help/

To prevent you from having to enter this URL every time you want to include a link you can define it to be your base hyperlink.

Select (File > Properties)(Summary tab) and enter this URL into the Hyperlink base text box.

Add the Individual Pages

All you need to do now to create a hyperlink to an Office Online article is enter the file name you want to link to.

Select (Insert > Hyperlink) to display the Insert Hyperlink dialog box.

Enter the text you want to display at the top and the file name at the bottom.

Things to Remember

If you want to add a hyperlink using a different prefix you can still just type the full URL into the address box.