Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Stop Excel from Auto Formatting Hyperlinks (3 Easy Ways)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for the future. Moreover, one interesting thing is that you can prevent auto-formatting hyperlinks for better operation. However, I have used Microsoft Office 365 for the purpose of demonstration, and you can use other versions according to your preferences. In this article, I will show you 3 easy methods of how to stop Excel from auto-formatting hyperlinks. Hence, read through the article to learn more and save time.


Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.


3 Suitable Methods to Stop Excel from Auto Formatting Hyperlinks

Often, we need to stop auto-formatting hyperlinks for certain business analytics, and the process becomes more interesting with Excel. However, the task is easy and simple. But you will need an arrangement in order to perform the operation properly. For the purpose of demonstration, I have used the following sample dataset. Here, the dataset contains 5 different Hyperlinks to some renowned websites.

How to Stop Excel from Auto Formatting Hyperlinks Dataset


1. Use AutoCorrect Option to Stop Formatting Hyperlinks

Fortunately, you can prevent auto-formatting hyperlinks by utilizing the AutoCorrect option in Excel. However, the process is quite simple and easy to operate. Hence, go through the steps below in order to complete the task in Excel easily.

📌 Steps:

  • In the beginning, go to the File tab.

  • Now, select Options.

  • Then, select AutoCorrect Options from Proofing.

  • Next, an AutoCorrect dialog box will appear, and select AutoFormat As You Type.
  • Afterward, uncheck Internet and network paths with hyperlinks option.
  • Now, press OK.

Use AutoCorrect Option to Stop Formatting Hyperlinks in Excel

  • Finally, paste links and Excel will stop auto-formatting those hyperlinks.

Read More: How to Stop Autocorrect in Excel for Dates (3 Quick Ways)


Similar Readings


2. Turn Off Auto Formatting Hyperlinks with Keyboard Shortcuts

Furthermore, you can apply Keyboard Shortcuts to stop Excel from auto-formatting hyperlinks. However, Microsoft Excel has plenty of shortcuts and those shortcuts help us to do work faster and also save time. Hence, go through the following steps in order to complete the operation.

📌 Steps:

  • Initially, select the cell where you want to paste the hyperlink. Here, I have selected cell C5.
  • Then, copy the link and paste it.

Turn off Auto Formatting Hyperlinks with Keyboard Shortcuts in Excel

  • Next, hit Enter.

  • After that, immediately press Ctrl + Z.
  • Finally, hyperlinks will be turned into normal text.

  • Similarly, you can do it for the rest of the links.

Read More: How to Stop Excel from Auto Formatting Numbers (3 Easy Ways)


3. Apply VBA to Stop Excel from Auto Formatting Hyperlinks

Last but not least, a VBA code can also help you to do a similar activity in Excel. A VBA code is necessary for this method. However, you can just copy the code and run it in your Excel worksheet. Hence, go through the following steps in order to complete the task properly.

📌 Steps:

  • Firstly, hold the Alt + F11 keys in Excel, which opens the Microsoft Visual Basic Applications window.
  • Secondly, click the Insert button and select Module from the menu to create a module.

Apply VBA to Stop Excel from Auto Formatting Hyperlinks

  • Thirdly, a new window will open and write the following VBA macro in the Module.
Sub StopHyperlinks()
Dim singleCell As Range
For Each singleCell In Selection
   singleCell.Hyperlinks.Delete
Next singleCell
End Sub

VBA Code to Stop Excel from Auto Formatting Hyperlinks

  • Fourthly, select all of your hyperlinks and press the F5 key to run the code.

  • Lastly, you will get your desired result.

Read More: [Fixed!] Why Is Excel Changing My Numbers? (4 Reasons)


💬 Things to Remember

  • First of all, you have to use the shortcuts immediately after pressing Enter.
  • Then, method 2 will not work if you have hyperlinks in a sheet from before. However, you have to input them instantly.
  • Next, you can change the VBA code according to your preference.
  • Afterward, method 1 is suitable if you don’t want any hyperlinks in your workbook.
  • At last, if you have pre-loaded hyperlinks in your workbook, you can apply method 3 in order to get the output directly.

Conclusion

These are all the steps you can follow to stop Excel from auto-formatting hyperlinks. Overall, in terms of working with time, we need this for various purposes. I have shown multiple methods with their respective examples, but there can be many other iterations depending on numerous situations. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

For more information like this, visit Exceldemy.com.


Related Articles

Mehedi Hasan

Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo