Missing Sheet Gridlines in Excel

Its a format

Ever seen a sheet with what looks like missing gridlines? Wondered what happened? The issue is a format.

If you have seen something like the image below and wondered what is going on, the answer is a Fill colour.

It is caused by the White Fill colour, which clears the grey gridlines.

Some people use it because they don’t realise you can turn off gridlines – see the View ribbon tab

To get rid of it just select the range and use the No Fill option.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

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

2 thoughts on “Missing Sheet Gridlines in Excel

  1. I’ve struggled with partial missing grid lines for a long, long time. “No Fill” an easy fix. Thanks.