Remove weird borders from Excel cell?

[Jyggalag]

Hi all,

I currently have an excel worksheet with this information:

Apologize for blurring out all the information. However, there are a bunch of weird borders around some of my cells that popped up when I started copy pasting data way back. Now, no matter what I do by filtering with "no border" or "erase border", it will not delete the borders.

I can copy paste blank cells on top which seems to do the job, but then I will lose some very much important information and formulas --> surely there must be an easier way to do this?

 

[Alex Blakenburg]

Lets start with checking if it is conditional formatting.
Press <F5> (Goto) > Special Cells > Conditional formatting > Enter
Are the problem cells now all highlighted ?

 

[Jyggalag]

Lets start with checking if it is conditional formatting.
Press <F5> (Goto) > Special Cells > Conditional formatting > Enter
Are the problem cells now all highlighted ?

You are a genius Alex. It was conditional formatting, I did not think about that at all!

Thank you so much for solving my issue!

 

[Alex Blakenburg]

No problem. Glad I could help.
PS: Saying that clear formatting didn't work but copying a blank cell over the top helped a lot.
I also know that conditional formatting will only allow you to do the thinner borders shown in your image.