Disable links in excel
DISABLE LINKS IN EXCEL CODE
Copy and paste the following code into the VB code window:.Double-click on ThisWorkbook in the VBAProject panel.Press the Alt + F11 hotkey to open the VB editor in Excel.So why not set up a macro that removes all hyperlinks from an Excel sheet? The complete Excel application includes a macro-recording tool to record macros, but you can also set up macros manually by entering the Visual Basic for Applications (VBA) code.
DISABLE LINKS IN EXCEL HOW TO
This Tech Junkie post (and its video) tells you how to record macros in Windows. Macros are a recorded sequence of selected options. The pasted cell now shows the URL without a hyperlink.In Excel at cell D3 or your preferred cell, right-click it and select Paste Text Only (T), which is the clipboard icon with the big letter A.As an example, copy the following URL:.Nevertheless, 2007 users can still remove links from spreadsheets using the “Paste Special” trick. As such, you can’t select that option in Excel 2007. Not all Excel versions include the “Remove Hyperlink” context menu option. Right-click on any cell and select Remove Hyperlink to convert all the links to plain text.To remove all hyperlinks from a sheet, press the Ctrl + A hotkey to select all the spreadsheet cells.Right-click on one of the selected cells and select the Remove Hyperlink option.To remove multiple hyperlinks from an Excel spreadsheet, hold the Ctrl key and select several cells with URLs at once.That will convert the hyperlink to a plain text URL. Then, you can right-click that cell and select the Remove Hyperlink option on the context menu.Open a blank Excel spreadsheet and enter in cell B2.If you’re using a more recent version of Excel, you can remove all the hyperlinks from a sheet with a context menu option. Using the Context Menu to Remove the Hyperlink Option Google Sheets doesn’t have the option to disable automatic hyperlinks, but you can remove all hyperlinks at once in a Google spreadsheet.If you want to have a list of plain text URLs, this is how you can remove all hyperlinks from Excel spreadsheets. Now when you type a web address ( in cell B2, it won’t be formatted as a link. Now you’re back in the Excel Options window. In the AutoCorrect window, go to the AutoFormat As You Type tab, uncheck Internet and network paths with hyperlinks, and click OK.Ĥ. In Excel Options, go to Proofing, and click on AutoCorrect Options.ģ. But if you want Excel to display links as regular text by default instead of creating hyperlinks, follow these steps:Ģ. There’s always the option to remove hyperlinks once they’ve been added. Let’s type in cell B2 and see what happens.Ĭell B2 is linked to the website, and your text is formatted as a link that will navigate you to the site with a click. For example, if you type in a cell, the cell is formatted as a link (underlined, with blue font), redirecting you to your default browser with a click. This tutorial demonstrates how to stop Excel from automatically creating hyperlinks.īy default, Excel recognizes all web addresses you type and turns them into links.