The currently selected worksheet is the default choice in the drop-down list to the right of the section title.

If you want to change the gridline color for a different worksheet, select that worksheet from the drop-down list.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

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

In your case, the hide feature may have been activated by mistake.

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.

Follow these steps to change the color to default again:- Step 1: Go to File - Options.

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.

It is better to go to Manage Rules and find out from the details if there is such a setting.

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.

How To Add Gridlines In Excel For Mac