Forum Discussion
Blue Triangles in Excel
- Mar 20, 2022
These are not triangles but lines with an arrow on one end.
Open the selection pane (ALT-F10).
Select a line object and delete it.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)
- HansVogelaarMar 20, 2022MVP
If you cannot attach a workbook to a reply, you might upload it to a cloud service such as OneDrive, Google Drive or Dropbox, and post a link to the uploaded file in a reply.
- richboisMar 20, 2022Copper Contributorthank you for the idea
- HansVogelaarMar 20, 2022MVP
The triangles are arrows whose line (shaft) has length 0.
To get rid of them:
Press F5 to activate the Go To dialog.
Click Special...
Select the Objects radio button.
Click OK.
All triangles are now selected.
Press Delete.
You'll have to do this for each sheet separately.