They distinguish cells from each other and make data in them more legible.

But depending on the kind of a data a worksheet contains, it may not have the gridlines.

As a result, it could become difficult for you to read across the rows.

If you want them to reappear, navigate to View tab and make sure the option Gridlines is checked under section Show.

On a white background, white gridlines are bound to hide themselves.

Step 2: Now click on Advanced and scroll to the section that reads Display options for this worksheet.

This is where you may select different colors if you wish to.

If you do not see any color there are chances that the overlay color selected is white.

Step 2: Go to Home tab and change the color fill option to No Fill.

So, navigate to Home - Styles - Conditional Formatting - Clear Rules.

Note: Clearing rules will clear all other rules along with the one you are trying to remove.

Bonus: Screen Properties None of the above seem to work for you Try and play around with the brightness and contrast of your screen.

I know it sounds absurd but at times, this could well be the reason behind those missing gridlines.

Conclusion Next time if you do not see gridlines on your worksheet you know what to do.

Also, remember that these settings apply to one sheet (selected sheet) at a time.

Did You Know Augmented Reality(AR) and Virtual Reality(VR) are similar but not quite the same.

Top 9 Ways to Fix Touchpad Gestures Not Working in Windows 10.

Why Does Excel Not Work For Mac