![removing hyperlinks in excel 2016 removing hyperlinks in excel 2016](https://cdn.ablebits.com/_img-blog/excel-remove-hyperlinks/paste-special-multiply-operation.png)
With the same level of zero difficulty, here are the steps for removing hyperlinks from the ribbon menu: Method 2 – Remove Hyperlinks from the Ribbon Menu It only appears on the context menu when the selected cells contain at least one hyperlink.
![removing hyperlinks in excel 2016 removing hyperlinks in excel 2016](https://images.tips.net/S02/Figs/T3281F1.png)
Note: It should be noted that Remove Hyperlinks option is not displayed all the time in the right-click context menu. This is what removed hyperlinks look like: Click Remove Hyperlinks option from the context menu.Īnd they're gone! These steps will remove the hyperlinks from the selected data, restoring the text back to the default format.Right-click on any one of the selected cells to open the context menu.For our example, we will select the range B2:C7. Select the cells, row, column, or entire sheet from where the hyperlinks need to be removed.Method 1 – Remove Hyperlinks from the Right-Click Context Menuīelow are the steps for removing hyperlinks using the right-click context menu: just plain text.įor our example, we have used color fill and different font weights, in the hyperlinked cells and borders on our table to show you the formatting changes that can occur after the hyperlinks are removed. The format of the cell from which the hyperlink is removed will be set to the default format of a regular cell black font color, default font and font size, no borders, color fill, etc. Now that we're all worked up over hyperlinks, here are some super simple ways of removing them from your sheets with super simple steps, leaving plain text behind. While Excel wouldn't be wrong to assume them as links, here's our guide to removing hyperlinks when you don't want Excel to behave in this way. It could be a created internal hyperlink, following data in the same workbook.Įxcel will pick up any URL, email address or file path entered in the sheet and turn it into a hyperlink. What is putting you off hyperlinks could be – not being able to single-click the cell, the time wastage of being redirected off your worksheet, or maybe the blue font is an eyesore? It might not just be automatic hyperlinking that you want to get rid of.
![removing hyperlinks in excel 2016 removing hyperlinks in excel 2016](https://oneminuteofficemagic.files.wordpress.com/2017/03/excel-hyperlinks-20170320-1.jpg)
Though it's not impossible to select a cell with a hyperlink – you can always double-click or navigate via the arrow keys on the keyboard. So when you try to click the cell containing a hyperlink to edit the cell content it opens that specific link in your default browser. The most common point of frustration regarding hyperlinks is the redirection when you do not want to be redirected. Hyperlinks might save you time, redirecting you to the link in your browser right when you click it, but this might also be the problem.