Archive for the ‘Hyperlink’ Category

» Using the HYPERLINK Function to create a Custom Hyperlink

The HYPERLINK function can also be used to create a hyperlink that can open a document stored on an intranet, a network server or the Internet. On clicking the cells that contain the HYPERLINK function, you can open the file stored at that links’ location.
Syntax
HYPERLINK (link_location, alternate_name)
Link_location: It is the filename or path of the [...]

» Setting the Base Address for Hyperlinks in a Workbook

The Unspecified paths to hyperlink destination files are always relative to the location of the active workbook. Use the following procedure if you want to set a different default path. In the ‘Insert Hyperlink’ dialogue box, while creating a hyperlink to a file in that location, you only need to enter the file name and [...]

» Selecting a Hyperlink without Activating It

For selecting the hyperlink without activating the link to its destination, perform one of the following actions.

Click the cell containing the hyperlink, hold the mouse button until the pointer becomes a cross (+) and then release it.
Make use of the arrow keys to select the cell containing the hyperlink.
To select a hyperlink represented by a [...]

» Learn More About Hyper Links

A hyperlink is defined as a link from a document that opens up a file or as page when the user clicks on it. The destination pages are mostly other web pages but they can also be pictures, email addresses or programs. The hyperlink itself can be a picture or text.
When the user clicks the [...]

» Deleting A Hyperlink

To delete a hyperlink, perform one of the following actions:
In order to delete a hyperlink and the text representing it, right-click the cell containing the hyperlink and then click ‘Clear Content‘ on the shortcut menu.
In order to delete a hyperlink and the graphic representing it, hold down the control key, click on the graphic and [...]

» Creating an Hyperlink to an Email Address

On clicking the hyperlink to an Email address, the email program will automatically start and create and email message complete with the correct address in the ‘To’ box. The above statement is only valid if you have an email program installed on your computer.
1.On the worksheet, click on the cell on which you want to [...]

» Creating an External Reference Link to Worksheet Data On the Web

Users can insert one or more external links (or references) from one workbook to another workbook located on your intranet or on the Internet. Users need to take care as to not save the workbook as an HTML file.
1.Open the source workbook. Select the cell or the cell range that you intend to copy.
2.Go to [...]