Articles

Creating hyperlinks in Excel that are relative & actually work

If you've ever tried to create a hyperlinks in excel you'll know what a pain they are. The hyperlink tool on the Insert ribbon is quite useful, but it is a pain to create a lot of them. The big problem however is that they are not relative - if you add more columns or rows suddenly your hyperlink is pointing to the wrong place. You could use the   more »