Forum Discussion
How to get rid of blue lines in excel
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)
Hi NiravJ1996
Likely to be conditional formatting... which you can clear as per the screenshot
Wyn
[MVP]
Hi NiravJ1996
Likely to be conditional formatting... which you can clear as per the screenshot
Wyn
[MVP]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.
