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 go...
Excel
Excel on Mac
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Nov 10, 2020

    Hi NiravJ1996 

     

     

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

     

     

    Wyn
    [MVP]

Wyn Hopkins's avatar
Wyn Hopkins
MVP

Hi NiravJ1996 

 

 

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

 

 

Wyn
[MVP]

Betspa's avatar
Betspa
Copper Contributor
Mar 04, 2024

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