How to get rid of blue lines in excel

[NiravJ1996]

Hey guys 

I want to know how to remove these blue lines that are popping up in my excel sheet. I tried removing borders and unchecked "view gridlines" as well but these blue lines are just not going away.

Can someone help?  (pic attached)

[#2 · Accepted solution]

Hi @NiravJ1996 

Likely to be conditional formatting... which you can clear as per the screenshot

Wyn
[MVP]

[#3]

@Wyn Hopkins Works! Thank you so much!!

[#4]

Hi @Wyn Hopkins 

I see you helped NiravJ1996 with a similar issue, i wonder if you can help me too.

I want to get rid of the grid lines between some cells but when i delete the grid lines i am left with blue horizontal ones, as if they were hiding beneath. I can't get rid of them. Also, there is a grey vertical line to the right of cell A that runs all the way down the page and will also not disappear. 

Do you know what's going on?

Thanks! 

Kyle

[#5]

I have random blue lines throughout my worksheet in Excel. I have already, several times, highlighted my entire sheet and clicked no border. This works on one sheet to be printed, but not on my main worksheet. I am trying to sort but when I highlight the table, not all the columns will highlight nor will the Sort (Data-Sort) work. It can't be clicked; it is greyed out. CTRL+A only highlights the portions with the blue lines, not all of my text (columns). I hope you can understand this inquiry. 

I also tried the Conditional Formating to no avail.