By default, whenever you type in a Web URL or an e-mail address, Excel will automatically convert it to a hyperlink. This is part of Excel’s AutoCorrect feature.
Oftentimes however, this is not what you want and you then need to go through the process of removing the hyperlinks from your cells. If you do not want Excel to create hyperlinks for you, you can disable this feature from the Excel Options area.
To Disable Automatic Creation of Hyperlinks in Excel
- Click the Microsoft Office button.
- Click the Excel Options button.
- Click the Proofing category in the left pane.
- Click the AutoCorrect Options button to display the AutoCorrect dialog box.
- Click the AutoFormat As You Type tab.
- Under “Replace as you type”, uncheck the box next to “Internet and network paths with hyperlinks.
- Click OK.
- Click OK.
Another way is to format the cell as a label by typing an apostrophe before the entry, such as ‘help@pcmcourseware.com. This will prevent Excel from automatically converting the entry to a hyperlink.
Similar Posts:
- Turn off AutoCorrect Features in Word 2007
- Inserting a Hyperlink in Excel 2007
- Disable Outlook’s AutoComplete Feature
- Disable the Mini-Toolbar in Word 2007
- Using a Named Range in Excel
- Apply Cell Styles in Excel 2007
- Find & Replace Formatting in Word 2007
{ 3 comments… read them below or add one }
Nice post! It’s great to see how different people customize their Excel experience! I’m glad that you shared this tip with us. The Excel community on Facebook could benefit from your knowledge and expertise! Check it out at http://www.facebook.com/office
Cheers,
Andy
MSFT Office Outreach Team
Thank you so much for this… The autogeneration of links was killing me, and figuring out where to deactivate wasn’t intuitive at all.
Glad I was able to help. Yes, I know what you mean…I find this “feature” quite annoying as well.