Blog


Creating hyperlinks in Excel that are relative & actually work

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   more »



Make a cell look like a button in Excel

Make a cell look like a button in ExcelThere a sometimes in excel where you want to create a button but you don't want to introduce VB into your workbook (there are many reasons not to) - heres how. I'm a great advocate of not using VBA / macros when you don't have to - they are not widely understood, easy to break when you alter the workbook and introduce a plethora of   more »



Share page

Subscribe to newsletter

Search Posts

Back to top