SOLVED

How to get rid of blue lines in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1870043%22%20slang%3D%22en-US%22%3EHow%20to%20get%20rid%20of%20blue%20lines%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870043%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20how%20to%20remove%20these%20blue%20lines%20that%20are%20popping%20up%20in%20my%20excel%20sheet.%20I%20tried%20removing%20borders%20and%20unchecked%20%22view%20gridlines%22%20as%20well%20but%20these%20blue%20lines%20are%20just%20not%20going%20away.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%3F%26nbsp%3B%20(pic%20attached)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-11-10%20at%2010.42.01%20AM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232487i086824219EBC2C1A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-11-10%20at%2010.42.01%20AM.png%22%20alt%3D%22Screenshot%202020-11-10%20at%2010.42.01%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1870043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1870182%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20rid%20of%20blue%20lines%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870182%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863416%22%20target%3D%22_blank%22%3E%40NiravJ1996%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorWyn%20Hopkins_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3ELikely%20to%20be%20conditional%20formatting...%20which%20you%20can%20clear%20as%20per%20the%20screenshot%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20613px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232496iA062171F1E8DD295%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWyn%3CBR%20%2F%3E%5BMVP%5D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1870185%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20rid%20of%20blue%20lines%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870185%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3BWorks!%20Thank%20you%20so%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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)

 

 

Screenshot 2020-11-10 at 10.42.01 AM.png

2 Replies
Highlighted
Best Response confirmed by NiravJ1996 (New Contributor)
Solution

Hi @NiravJ1996 

 

 

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

 

image.png

 

Wyn
[MVP]

Highlighted

@Wyn Hopkins Works! Thank you so much!!