• Skip to main content

masteryourtech.com

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
You are here: Home / Excel / How to Disable Automatic Hyperlink in Excel for Office 365

How to Disable Automatic Hyperlink in Excel for Office 365

posted on March 17, 2019

Excel includes several convenience features that are meant to make it easy for you to create and edit data within the cells of a spreadsheet. One of these features is the ability to turn file paths and Web page URL into hyperlinks whenever you type one.

While the ability for people reading your spreadsheet to simply click on one of these links can be helpful, you might actually prefer to enter those file and Web locations without automatically turning them into clickable links. Luckily this is a setting that you can change in Excel.

How to Stop Excel from Automatically Turning File and Web Addresses into Hyperlinks

The steps in this article were performed in the Excel for Office 365 version of the application, but will also work in other versions of the program. Note that you will still be able to manually create hyperlinks if this setting is disabled.

Step 1: Open a file in Excel.

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

open the excel file menu

Step 3: Choose the Options button at the bottom-left of the window.

open excel options menu

Step 4: Select the Proofing tab at the left side of Excel Options.

select the proofing tab

Step 5: Click the AutoCorrect Options button.

open the autocorrect options menu

Step 6: Choose the AutoFormat as You Type tab.

select the 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, then click OK at the bottom of the window.

how to disable automatic hyperlinks in excel

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

Note that this setting will remain for other new and existing files into which you type Web and file addresses in the future, but will not affect any existing hyperlinks.

If the button is grayed out on the Proofing tab, then you probably don’t have a file open. For some reason the AutoCorrect Options button is grayed out unless a file is open.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Filed Under: Excel

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2022 MasterYourTech.com

 

Loading Comments...
 

You must be logged in to post a comment.