• Skip to main content

Master Your Tech

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.

Matthew Burleigh
Matthew Burleigh

Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.

Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.

The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.

You can read his full bio here.

Share this:

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

Filed Under: Excel

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2023 MasterYourTech.com