Some gridlines are not visible in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have received an Excel workbook - most gridlines are visible, but some of
these not. Any ideas about the cause and how to turn all gridlines visible?
Many thanks,
Koen
 
Go to Tools->Options->View and make sure Gridlines is checked. If it is
already checked, ensure the color is set to black or dark gray.
 
If just some cells, probably due to the background color of those cells being
set to White.

The background color wipes out the gridlines.

Set to "Automatic" to see gridlines.


Gord Dibben MS Excel MVP
 
Indeed: I've selected all cells and went to Format, Cells, Patterns and
changed the cell shading color from white to No Color. This solved the issue.
Many thanks to both of your for your feedback,
Koen
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restoring Gridlines 3
How do you add or remove gridlines from an individual cell? 3
Excel links in Word 1
GRIDLINES 7 FILL COLOR 4
Blank Sheet with Gridlines 11
text on worksheet with no gridlines 2
Pasting charts to Word without Gridlines 7
Gridlines dissappeared behind formated cells. Get them back? 1

Back
Top