Functionality of hyperlinks in Excel?

Jake

When I export the receipts to Excel, I have to double click on every hyperlink (appears as normal text) to enable it actually hyperlink (causing it to change to blue and function as a hyperlink). What am I missing here? Is there a way to increase functionality without having to click on very individual line? I'm currently using Excel in Office Professional Plus 2013. TIA.

Aussiebandit

Hi @Jake - yes this is frustrating but if you use this formula in Excel

=HYPERLINK(cell, cell)

eg =HYPERLINK(A1,A1) in the next column and copy down, it will convert them to hyperlinks for you.

Jake

Thank you very much, Aussiebandit! That will ease the pain...

Sheena Trepanier

Hi @Aussiebandit - Thanks for this fantastic tip, I've shared it around with the team and will also look into whether or not we can help with the links on our end.

If I have any new information to share I'll update this thread!