Using Hyperlinks Functions In Your Excel Files To Increase Productivity

One of the key things that I use excel for is actually something that you might not know is possible. This is a very different function than the type that I usually discuss here but I personally save a lot of time every day. Basically, both at home and at work, I use excel as a quicker way to access certain documents or places in order to both save:

-time
-avoid having to always think about where a specific file is saved

How do I do it?

In any excel file, I simply write down the name of the files that I wish to link to, it can also be a directory, or even a webpage. Here are some of the things you could link to:

-excel file
-directory
-email
-etc

Here is what it would look like:

Then, you can simply add the hyperlinks, simply select the cell and then click on “insert/hyperlink”

You can then select the type of link on the left side and then browse to the document in question.

The text on your excel file will change color as you can see here:

In fact, you can even write the subject of the email (in cases where you send the same email to the same people often). I’m telling you, just start using it and you will never want to go back:)

Unfortunately, since the paths would be different from one computer to another, I cannot really make this file available for download, but feel free to ask any questions regarding the hyperlink function, I’ll be more than happy to help.

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss

***************************************************