Creating an Excel hyperlink – Part 02 | Linking to other files – using named ranges

In a previous post, I covered some of the basics of using hyperlinks to link to other documents but today I’m going to show you how to link to specific cells (or if you are feeling a bit adventurous :-)) to some named ranges. Also note that you can hyperlink to websites, or other non-Excel documents as well….

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/Hyperlinks_part_two.mp4′]

Here are the two files I used in the exercise.

February_with_named_range

January