How to remove links in Excel workbook?

Sometimes users forget that they have created links in worksheets and wonder how to remove links from Excel workbook. Even if you have created a link accidentally to a location in the spreadsheet, you can remove the link with the following method:

How to remove hyperlink in Excel workbook?

The hyperlink in Excel workbook is created when you press Ctrl+K and click the cell where you want to hyperlink to. Now, you can remove hyperlink in Excel workbook using the below methods:

How to remove hyperlink in a worksheet in Excel?

Go to the Data tab in the Excel menu bar, click the Connections icon. You will see the list of all the connections in the workbook. Click the ellipsis (…) icon next to the hyperlink you want to remove. A new window will open in which you will be able to see the connection properties. To remove the hyperlink, click the Remove button.

How to remove link in an Excel workbook?

To remove the links in an Excel workbook, click on the File menu and go to the Export option. Now, select the type of data you want to export. Next, choose the location where you want to save the file. Once you have completed the steps, click on the Save button. After this, press the Save & Exit button. Now, open the Excel file that you have just saved. After doing this, you will notice that the hyperlink has been removed from the cells.

How to remove link in Excel workbook?

If you have created a hyperlink in Excel spreadsheet, you can remove the hyperlink by right clicking on the cell and removing the hyperlink. However, if you made a hyperlink based on an existing cell, then the cell itself will not contain a hyperlink. In such a case, to remove the hyperlink, you will need to select the hyperlinked cell and click on Remove Hyperlink from the menu.