Unselect this option and Excel will disable the automatic inserting of hyperlinks in tables.Ĭonfirm with OK and let’s try it out together. Go to the tab ‘AutoFormat As You Type’ and find the tick box ‘Internet and network paths with hyperlinks’. Find and select ‘Proofing’ and click on ‘AutoCorrect Options’. Go to ‘File’ in the top left corner of the screen. And here comes the good news – this automatic hyperlinking can be disabled. Usually, if you enter a web link or an email address into a cell, Excel automatically inserts the hyperlink.
#How to remove hyperlink in excel how to
Then carry on as we did previously – right-click, select ‘Remove hyperlinks’ and Excel will remove all hyperlinks in the spreadsheet.īut we’re still not done here! How to Turn Off or On Automatic Hyperlinks in Excel To remove all hyperlinks across the spreadsheet, click on the upper left corner, which will highlight the whole sheet as selected. How to Remove all Hyperlinks Across the Spreadsheet in Excel
For example, we can add ‘4’ into the text to display, and we’ll add ‘4’ into this email address, too.Ĭlick on OK and you’ll see that the change has taken place right away. In this pop-up window, you can edit the displayed text. If you simply want to edit the hyperlink, select the cell with the hyperlink, then do the right-click again, but now choose the option ‘Edit hyperlink’. To remove an individual hyperlink, make sure to select the cell containing the hyperlink, then click the right mouse button and choose the option ‘Remove hyperlink’. How to Remove an Individual Hyperlink in Excel
In case you want to avoid having hyperlinks included in data tables, you can remove them and there’s more than one way to do that.
4 How to Turn Off or On Automatic Hyperlinks in Excel
0 kommentar(er)
