Forum Discussion
How to get rid of symbols after deleting hyperlink
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
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!
3 Replies
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!
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!
