SOLVED

Blue Triangles in Excel

Occasional Contributor

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

richbois_0-1647687327808.png

 

14 Replies

@richbois 

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5
 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

thank you for your reply but I can seem to be able to attach my file

@richbois 

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.

thank you for the idea
best response confirmed by NikolinoDE (Respected Contributor)
Solution

@richbois 

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 

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.

thank you very much for the solution It does work but will it affect anything else in the spreadsheet????
Thank you Hans this solution is also great
No.
Thank you all for your help
Hans's solution works good for that workbook but Detlef's solution is better for some of my other workbooks as there is other shapes and rectangles that would get deleted. I can go to just the lines items and hide them.

again thanks
Richard
You should not hide them but delete them.

@richbois 

Thank you for your feedback.

I am glad that you have helped you with these tips from Detlef Lewin & Hans Vogelaar .

As you can see afterwards, with the right description you will always get an answer in this forum :).

Welcome to your Excel discussion space!

I agree and realized that just now as you were posting