How to get rid of symbols after deleting hyperlink

Occasional Contributor

Hi, can anyone help please?  How do I get rid of these symbols in bulk? I know I can go on individually right click and delete (and again).  TIA, Jella 




3 Replies


Press F5 or Ctrl+G to activate the Go To dialog.

Click Special...

Select Objects, then click OK.

Pressing Delete will now delete ALL objects on the sheet, so be careful!

@hans_Vogelaar That's a bit scary as there is a lot of information already on the worksheet that I need to keep. Anyway around that?
best response confirmed by Jella510 (Occasional Contributor)


On the Home tab of the ribbon, in the Editing group, select Find & Select > Select Objects.

You can now use the mouse to drag a rectangle around all the items that you want to delete. Make sure not to include any other objects. If you do, you can Ctrl+click a selected item that you want to exclude.

Press Delete to remove the selected objects.

Finally, don't forget to turn off Select Objects!