I don't know about you, but I keep struggling with Excel spreadsheets that contain email addresses or links to URLs. Whenever you just want to mark them, you call up the website or the mail program and sometimes the marking works without problems for whatever reason. When I was working with Internet addresses in an Excel table yesterday, the problem came back to me again and I wanted to finally find out how the marking of such table cells now works.
Chapter in this post:
Microsoft Office Support Forum explains how to do it
After a brief visit to Google, I found what I was looking for: the Microsoft support forum has dealt with the problem a solution, because apparently it wasn't just me that marking the cells resulted in unwanted visits to websites. :)
Instructions: How to mark correctly!
So here is a short summary of the way to mark table cells if they contain a URL or an e-mail address:
To highlight a cell in the Excel desktop application that contains a hyperlink without jumping to the hyperlink destination, click the cell and hold the mouse button down until the pointer changes to a cross. Then release the mouse button.
To be honest, “holding down” works for me to the extent that I can mark the cell without any further action. But unfortunately my hand doesn't change when I click on the cell - it just remains one hand. :-)
Prevent conversion of emails and internet addresses
If you want to completely prevent e-mail addresses or Internet addresses from being converted into clickable strings, you can do this in the Excel settings and switch it off.
To do this, go to the “AutoCorrect” settings in the settings and tick the “Replace Internet and network paths with hyperlinks” checkbox.
Related Articles
Jens has been running the blog since 2012. He acts as Sir Apfelot for his readers and helps them with technical problems. In his spare time he rides electric unicycles, takes photos (preferably with the iPhone, of course), climbs around in the Hessian mountains or hikes with the family. His articles deal with Apple products, news from the world of drones or solutions to current bugs.