#How to make hyperlinks in excel 2016 free
Currently, in the file you download, column A is labeled for URL’s, but thats not a requirement, so feel free to change it.Ĥ. Import or paste your links into an empty version of the spreadsheet. Hit “Options” to enable the macro by choosing “Enable This Content” and checking the radio button that says “Enable macros in this document”.ģ.
#How to make hyperlinks in excel 2016 download
Download the spreadsheet, and note the “security” warning that will appear (in Excel 2007) above column A, which simply tells you that there’s a macro in need of enabling.Ģ.
If you prefer to download a sample sheet with the embedded macro you can see it here, and you’ll need to follow these steps:ġ.