[April fool] – Invisible Gridlines?

Well… if you get bored in work on April fool, if you want to have a little fun with your colleague who is busying with his/her Excel files, here’s a minor trick for you to play with… Cautions: Take your own risk… 🙂

Excel Tips - Gridline color.gif

Well, you may think that either the Fill Color or Border Color is set to “White” to the whole worksheet, which is not uncommon indeed.


Excel Tips - Gridline color1

But this is not the case… 😦 

So where the gridlines go?

Try the following:

File –> Options –> Advanced (Scroll down to middle)

Excel Tips -Gridline color3

Check if the Gridline color is set to “White”…

Switch it back to “Automatic” and you will see the gridline again.

So you don’t have to panic when you couldn’t see the gridlines on your Excel sheet next time.  Go check the Gridline color (and probably review your working relationship to the colleague who sent you the file).  Who is going to change that setting intentionally for no purpose? 😛


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.