There are many ways to batch cancel hyperlinks in Excel cells, but versions before Excel 2010 do not provide a direct method. In Excel 2010, you can directly use the commands in the ribbon or right-click menu.

Select all cells containing hyperlinks. There is no need to press the Ctrl key to select one by one, as long as the selected area contains cells with hyperlinks. To remove all hyperlinks in a worksheet, press Ctrl+A or click the Select All button at the intersection of row and column labels in the upper left corner of the worksheet to select the entire worksheet. Select the "Home" tab in the ribbon, and in the "Editing" group, click "Clear → Clear Hyperlinks" to cancel the hyperlink. But this command does not clear the cell format. If you want to cancel the hyperlink and clear the cell format at the same time, select the "Delete Hyperlink" command.

Excel2010

You can also right-click the selected area and select the "Delete Hyperlink" command in the shortcut menu to delete the hyperlink.

The above is the method of batch deletion of hyperlinks in Excel 2010 shared by the editor. I hope it will be helpful to everyone! For more exciting tutorials, please pay more attention to Huajun Software Park!