Forum Discussion
richbois
Mar 19, 2022Copper Contributor
Blue Triangles in Excel
I just upgraded from Office 2010 to Microsoft 365 I am getting these blue triangles inn my spread sheets could someone help me get rid of them Thank you Richard
- 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.
richbois
Mar 20, 2022Copper Contributor
thank you for your reply but I can seem to be able to attach my file
HansVogelaar
Mar 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.
- richboisMar 20, 2022Copper ContributorThank you Hans this solution is also great