Excel Training Videos

What's new in Excel training? Questions and Answers

How to avoid hyperliks during data entry in Excel?
In the last few days I've received many emails asking how to avoid '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.
What's new in Excel training?