New
#1
Hyperlinks in Excel - can I do this?
Hi folks,
I hope there is an answer to this question - it is driving me mad.
I'm editing an Excel spreadsheet (Excel 2016) about properties I'm looking to buy.
The spreadsheet has fields for type, bedrooms, address, etc and a cell for a hyperlink to the property listing.
What is driving me mad is that if I click on a cell containing a hyperlink, Excel automatically opens that hyperlink in my browser. When formatting cells, this happens time and again and is really annoying me.
Is there any way to change the behaviour so that if I want to follow the hyperlink I press another key (such as CTRL) whilst clicking on the cell and if I don't want to follow the link, nothing happens when I click that cell?
Thanks in anticipation,
Art