Nov 09 2020 06:43 PM
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)
Nov 09 2020 08:08 PM
SolutionHi @NiravJ1996
Likely to be conditional formatting... which you can clear as per the screenshot
Wyn
[MVP]
Nov 09 2020 08:17 PM
@Wyn Hopkins Works! Thank you so much!!
Feb 23 2023 01:47 AM
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
Mar 04 2024 01:25 PM
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.
Nov 09 2020 08:08 PM
SolutionHi @NiravJ1996
Likely to be conditional formatting... which you can clear as per the screenshot
Wyn
[MVP]