excel training seminar - Hyperlink

Hi Tom. This is tricky, but not impossible. One way is to use Data Validation on your cell and choose the list option. Build the list of hyperlinks elsewhere in your spreadsheet and use that as your source list. When the validation is in place, a drop down will appear with the urls in them, allowing the user to select them.

Hope this helps,

Anthony