Forum Discussion

NiravJ1996's avatar
NiravJ1996
Copper Contributor
Nov 10, 2020

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]

    • ShutterStJames's avatar
      ShutterStJames
      Copper Contributor

      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

       

    • Betspa's avatar
      Betspa
      Copper Contributor

      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.

Resources