Today a colleague told me they were going crazy because they kept accidentally clicking on emails in an email list they maintained in Excel. I said, why don’t you turn off the hyperlinks then you will not have to worry about it. My colleagues face went blank….”You can do that?”.
Steps to disable auto hyperlinks (pre Excel 2007):
- Go to the tools menu and select “auto correct options”.
- Select the “AutoFormat as you type” tab
- The first option is “Internet and network paths with hyperlinks”. Deselect this option.