Forum Discussion

Gustave van Meerbeke's avatar
Gustave van Meerbeke
Copper Contributor
Oct 19, 2018

hyperlinks

I have a number of folders with lots of individual file names (representing pictues) which I want to "hyperlink" into a spreadsheet. I can do that one by one using the menu, but I wonder if there is a faster way of getting this donkey work done.  

 

Regards and thanks for yr attention

 

Gustave van Meerbeke

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Have a look at the HYPERLINK worksheet function:
    =HYPERLINK("file://"&A1)

Resources