learn microsoft excel

How to avoid hyperlinks during data entry in Excel

Home
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
About Us
Free Ebook
Offline Training

Our Youtube Videos


Automatic creation of hyperlinks while entering a web address or an email address is a cause of frustration for many users. In the last few days we have received many emails asking how to avoid these automatic 'hyperlinks' while entering data in Excel. For example, if you write an email address into an Excel cell like tak@abc.com, it is automatically 'hyperlinked'. Or if you type a web address like http://www.familycomputerclub.com, it automatically creates a hyperlink. How can the user avoid this?

Let's see how this can be achieved in both Excel 2003 and 2007.

In Excel 2003:
  • Click on 'Tools' in the menu bar
  • Select 'options...'
  • Click on 'spelling'
  • Click on 'AutoCorrect Options...'
  • Click 'Autoformat as you type' and deselect 'Internet and network paths with hyperlinks'.
    In Excel 2007:
    • Click on the 'Office Button'
    • Select Excel Options.
    • In Excel options window select 'Proofing' on the left top
    • Select 'AutoCorrectOptions..'
    • Click Autoformat As You Type' and finally deselct 'Internet and network paths with hyperlinks'.
    • Click 'OK' to complete the process.
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Our Youtube Videos