HOW TO GENERATE A HYPERLINK TO A DIFFERENT FILE - Microsoft Office 2016: The Complete Guide (2015) 

Microsoft Office 2016: The Complete Guide (2015)

HOW TO GENERATE A HYPERLINK TO A DIFFERENT FILE

Go to a new worksheet in excel and select the cell where the hyperlink will be created.

TIP- Excel also provides the option to use objects, such as pictures or an element to represent a hyperlink.

Then select either of these options:

Go to the Insert tab, and under the Links group, select Hyperlink.

Choose the cell or image, and then go to the Hyperlink option, or you can use the keys Ctrl+K.

Then go to the option Link to and select Create New Document.

A box will appear with the heading Name of new document, insert the name of the file.

TIP   You can go to the Name of new document box to change the location of a file path from the one that is stated under the option Full path. You may also choose to select the Change to select the location that you desire and then choose OK.

Go to the When to edit, and select either the option Edit the new document later or Edit the new document now.  This will give an indication of the specific time the file should be edited.

Go to the Text to display box, and type the text that will be used to represent the hyperlink.

By selecting ScreenTip, you will be able to view helpful tips and information, when the pointer is placed on the hyperlink. ScreenTip text box, and then click OK.

Select OK.