How to get rid of blue lines in excel

Wyn Hopkins Works! Thank you so much!!

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

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.