Removing unwanted hyperlinks in Microsoft Excel can be a tedious task, especially when dealing with hundreds of links scattered throughout your worksheet or workbook. In this guide, we will show you how to quickly remove all hyperlinks in a range using the Remove Hyperlinks command and also explain how to turn off hyperlinks directly while creating them.

To begin with, navigate to the 'Data' tab on the right side of the Excel window and select the option 'Remove Hyperlinks.' This command is only available in Excel 2010 and later versions. In the 'Edit Links' window that appears, you will see options like 'Update values,' 'Change Source,' 'Open Source,' and 'Break Links.' These options can be used to reload values, change referenced files, open linked excel files, or break links respectively.

If you want to remove all hyperlinks in a range quickly, follow these steps:

1. Select the entire range that contains the unwanted hyperlinks.

2. Go to the 'Data' tab on the ribbon and select the option 'Edit Links.'

3. In the 'Edit Links' window, click on the 'Find All' button.

The resultant will be a set of external references used in your worksheet or workbook. To remove these links, navigate back to the 'Remove Hyperlinks' window and click on the 'Break Links' option.

Alternatively, you can disable links directly while creating them by following these steps:

1. Open your Excel sheet and navigate to the 'Data' tab.

2. Click on the 'Edit Links' option inside the 'Data' tab.

3. In the 'Edit Links' window, select all the spreadsheets referenced in your excel file.

Please note that this option will only become active if your sheet contains some external references. Essentially, the edit link option displays all other files to which your spreadsheet is linked to. By using this option, you can easily verify if your Excel sheet contains external references or not.

In conclusion, removing unwanted hyperlinks in Excel 2010 and later versions is a straightforward process that involves navigating to the 'Data' tab and selecting the 'Remove Hyperlinks' command. Additionally, by disabling links directly while creating them, you can save time and avoid dealing with hundreds of links scattered throughout your worksheet or workbook.

How to disable links in excel 2010