Jump to content

Excel - permanent hyperlink disablement?


Mittens

Recommended Posts

My entire account base is in an Excel spreadsheet that I use all day, every day.  One of those sheets has contact info for all of the vendors we use.  I need their emails in there, but I'm never going to use them as a hyperlink to open an email from the spreadsheet. I do need to copy/paste them fairly regularly, and if I do that w/ an individual cell, it goes right back to a hyperlink as soon as I leave the cell.

tldr: I want to lock the spreadsheet as "Remove Hyperlink" for all of eternity.  Is there a way to do this?

Link to comment
Share on other sites

Excel 2013 and Excel 2010:

Click on the File tab.

Click on the Options button at the bottom of the menu window.

Click on Proofing in the list on the left.

Click on the Autocorrect Options... button.

Click on the Autoformat As You Type tab.

Click to deselect (remove the tick from) the Internet and network paths with hyperlinksoption.

Click OK back out through the menus.

 

  • Hook 'Em 2
  • Drool 1
Link to comment
Share on other sites

On 1/7/2025 at 11:43 AM, blacklab said:

Excel 2013 and Excel 2010:

Click on the File tab.

Click on the Options button at the bottom of the menu window.

Click on Proofing in the list on the left.

Click on the Autocorrect Options... button.

Click on the Autoformat As You Type tab.

Click to deselect (remove the tick from) the Internet and network paths with hyperlinksoption.

Click OK back out through the menus.

 

My God this board is awesome.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...