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:

Support Sir Apfelot on SteadyHQ

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, it works for me with the "hold down" button to such an 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" item in the settings and tick "Replace Internet and network paths with hyperlinks".



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 or at Patreon would support.

Leave a Comment

Your e-mail address will not be published.