How to Remove Hyperlinks in Microsoft Excel
Want to remove those clickable links from your Microsoft Excel spreadsheets? If so, it’s easy to remove those links or completely prevent Excel from turning your typed text into web links. We’ll show you how to do both.
RELATED: How to Remove Underline Hyperlinks in PowerPoint
How to delete a single hyperlink in Excel
To quickly remove an individual hyperlink from your Excel spreadsheet, use an option on your context menu.
To do this, first open your spreadsheet with Excel. Find the cell containing the link you want to remove.
Right-click on this cell and, in the menu that opens, select “Remove hyperlink”.
And your selected hyperlink is now deleted.
That’s it. You can Remove hyperlinks from Word documents in the same way.
RELATED: How to Remove Hyperlinks from Microsoft Word Documents
How to remove multiple hyperlinks in Excel
If you want to remove multiple hyperlinks from your Excel worksheet at once, again you can use the Excel context menu option.
To do this, first open your spreadsheet with Excel.
In the spreadsheet, select the links you want to remove. You can select as many links as you want.
To remove links from your entire spreadsheet, press Ctrl+A (Windows) or Command+A (Mac) to select your entire spreadsheet.
While your hyperlinks are selected, right-click anywhere on your spreadsheet and choose “Remove hyperlinks” in the menu.
And Excel will remove all your selected hyperlinks!
You are ready. If you enter a lot of dates in Excel, you may want to know how to convert text to date values.
How to prevent Excel from turning your links into hyperlinks
By default, when you enter a web address in your spreadsheet, Excel automatically converts it to a hyperlink. To avoid this, you can disable an option in Excel settings.
To do this, in the upper left corner of Excel, click “File”.
From the left sidebar, select More > Options.
You will see a window “Autocorrect”. At the top of this window, click “Auto format as you type”.
In the tab “Auto format as you type”, in the section “Replace as you type”, disable the option “Internet and network paths with hyperlinks”. Then click on “okay”.
Close the window “Excel Options” clicking on “okay” downstairs.
Now, Excel will no longer automatically convert your text to hyperlinks. Very useful in many cases!
Likewise, you can also disable automatic hyperlinks in Microsoft Word.
RELATED: How to Disable Automatic Hyperlinks in Microsoft Word