How to Create Hyper Links to Files in Your Computer using MS-Excel and MS-Word?

Author Udaya Chandran

Monday, June 2, 2014

Share :

Tweet

If you have more and more important files in your computer and if you want to find them quickly and to avoid the time for searching them, you can use create links using the option ‘Hyperlink’ in both MS-Excel and MS-Word.

First create the list of files you want either in Excel or Word as an example below:

1. Bank & Cash Balance

2. Daily Expenses Report

3. Purchase Report

4. Sales Report

The next step is to highlight a particular file type

Right Click à Choose the option and click ‘Hyperlink’ à a pop up window named ‘Insert Hyperlink’ will open

In that pop up window you can see ‘Look in’ à Choose the folder in which the file exists

Choose the file for which you want the link à Click ‘OK’

The hyperlink is created for that file.  If you want to open the file, just place the cursor on the link and press the ‘Ctrl’ + click the link.  The file will be opened.

To create the link for files in Excel file, just follow the same steps.  After creating the link in Excel file, you need not to press ‘Ctrl’ to open the file.

Tag : Computers, MS-Excel, MS-Office, MS-Word, Tutorials