You can remove a hyperlink from a single address, remove many links at once, turn automatic hyperlinks off, and turn off the requirement to press Ctrl to follow a hyperlink.
Remove a hyperlink
To remove a hyperlink but keep the text, right-click the hyperlink and click Remove Hyperlink.
To remove the hyperlink completely, select it and then press Delete.
In Excel:
If the hyperlink was created using the HYPERLINK function, you can remove the hyperlink by using the following steps:
-
Select the cell containing the hyperlink.
-
Press CTRL+C to copy the hyperlink.
-
Right Click and paste using the Values paste option.
Remove all hyperlinks at the same time
If you're using Word, Outlook, or Excel, you can remove all hyperlinks in a file by using a keyboard shortcut.
In Word and Outlook:
-
Press Ctrl+A to select all text.
-
Press Ctrl+Shift+F9.
In Excel:
-
Select all cells that contain hyperlinks, or press Ctrl+A to select all cells.
-
Right-click, and then click Remove Hyperlinks.
Turn off automatic hyperlinks
When it’s not convenient to have Office automatically create hyperlinks in your document as you type, you can turn them off.
-
Click File > Options > Proofing.
(In Outlook, click File > Options > Mail > Editor Options > Proofing.)
-
Click AutoCorrect Options, and then click the AutoFormat As You Type tab.
-
Clear the Internet and network paths with hyperlinks check box.
Turn off Ctrl+Click to follow a link
By default, Word and Outlook require you to press Ctrl when you click to follow a hyperlink. This extra step keeps you from accidentally going to a linked destination while you’re editing a document.
If you want to click links without having to press Ctrl, try this:
-
In Word, click File > Options > Advanced.
In Outlook, click File > Options > Mail > Editor Options > Advanced.
-
Under Editing Options, clear the Use CTRL + Click to follow hyperlink check box.
