Please follow the steps below to clear the hyperlinks in a worksheet:
Step 1: Select the whole worksheet by clicking the top left corner;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Clear" in "Editing" section and click "Clear Hyperlinks";
Alternatively, select the whole worksheet, right click and select "Remove Hyperlinks" from the list.
Step 4: You will remove all hyperlinks.