You can select a single cell, group of cells, or the entire worksheet. If you would rather retain the formatting when removing hyperlinks, there’s another technique: Clear Hyperlinks Without Changing Format Settings Formatting of other cells, however, remains unchanged. This also removes all hyperlinks in the worksheet as well as any formatting done on the cells with links.
#DISABLE HYPERLINKS IN EXCEL 2016 HOW TO#
We will also show you how to disable Excel from automatically converting anything to a hyperlink. In this tutorial, we are going to look at how you can remove hyperlinks from a single cell, multiple cells, and a whole worksheet. This could mislead someone else going through your spreadsheet.įor all the above cases, the best solution would be to either remove the hyperlinks, so the cell contents behave and look like regular text, or to disable automatic hyperlink conversions altogether.
But this slows you down and is not helpful at all when you’re trying to get important work done.
#DISABLE HYPERLINKS IN EXCEL 2016 PLUS#
You can click on the cell and hold your mouse button till the pointer turns into a plus symbol. This can feel more like unsolicited assistance and waste a lot of time. This is because when you click on the cell, Excel opens up your default browser and directly takes you to that link. It’s difficult to select, copy, and delete cells containing hyperlinks.When you have some hyperlinks in your worksheet, you may feel some level of frustration dealing with it (at least I do).īelow are some of the issues you can face when you have hyperlinks in your workbook: Issues when Working with Hyperlinks in Excel Turn off Automatic Hyperlink Conversion for all Worksheets.Clear Hyperlinks Without Changing Format Settings.Remove all Hyperlinks from the Entire Worksheet.Issues when Working with Hyperlinks in Excel.