How to Disable Automatic Hyperlink in Excel 2010

Microsoft Excel has come to a point where its’ default settings are going to be as useful as possible for the majority of people. However, there are still some settings that tend to irritate a lot of users. One such setting involves the practice of Excel automatically turning a Web URL or email address into a hyperlink. While this can be beneficial at times, it can be very annoying if you are just recording that address for informational purposes and do not intend to use the hyperlink. Fortunately you can change this behavior and take a step to making Excel behave in the manner that is best for your needs.

Are you interested in Windows 8? Learn more about this exciting new operating system to see if it is something that you might want.

 

Turn Off Auto Hyperlink in Excel 2010

 

Note that, after you make this change, existing hyperlinks will remain as hyperlinks, and you can elect to turn a URL or email address into a hyperlink if you still wish to do so. Making this change in Excel 2010 simply reverses the behavior so that you will need to actively turn something into a hyperlink instead of having it done automatically for you.

 

Step 1: Launch Microsoft Excel 2010.

Step 2: Click the File tab at the top of the window.

Step 3: Click Options at the bottom of the column on the left side of the window.

excel options menu

 

Step 4: Click Proofing in the column at the left side of the Excel Options window.

excel options proofing tab

 

Step 5: Click the AutoCorrect Options button at the top of the window.

autocorrect options

 

Step 6: Click the AutoFormat As You Type tab at the top of the window.

autoformat as you type tab

 

Step 7: Click the box to the left of Internet and network paths with hyperlinks to remove the check mark.

how to disable automatic hyperlinks in excel 2010

 

Step 8: Click the OK button at the bottom of the window.

 

Have you ever wondered how to combine multiple columns into one column in Excel? Such as if you have one column for first names and one column for last names, but you want just a single column with both? Read this article to learn how to combine columns in Excel.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.