EXCEL tip: Mark cells with links and e-mails without calling up hyperlinks

Nicrosoft Office Excel Tips

Nicrosoft Office Excel TipsI 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.

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.

Microsoft Office Excel Settings> Autocorrect
Microsoft Office Excel Settings> Autocorrection - this is how you prevent the automatic replacement by hyperlinks.

To do this, go to the “AutoCorrect” settings in the settings and tick the “Replace Internet and network paths with hyperlinks” checkbox.



My tips & tricks about technology & Apple

Did you like the article and did the instructions on the blog help you? Then I would be happy if you the blog via a Steady Membership would support.

Post a comment

Your e-mail address will not be published. Required fields are marked with * marked

In the Sir Apfelot Blog you will find advice, instructions and reviews on Apple products such as the iPhone, iPad, Apple Watch, AirPods, iMac, Mac Pro, Mac Mini and Mac Studio.