Cell grid lines won't show up, and have box checked

F

Fran Jones

I imported a file from Quattro Pro. The data looks fine but the cell grid
lines don't show up, and I have the grid line box checked under
format/display. Any ideas?
 
R

Ragdyer

How about in:
<Tools> <Options> <View> tab,
And under "Window Options", make sure "Gridlines" *IS* checked,
*AND*, the color is "Automatic".
 
C

Cutter

Try formatting all the cells as having no background fill colour. The
may presently be formatted as having white background fill colour
 
G

Gord Dibben

Fran

Select all cells then Format>Cells>Patterns>No Color


Gord Dibben Excel MVP
 
J

JNelson

I had symptoms where some of the grid lines would print and some would not.
It also was inconsistent with spreadsheets. Sometimes it would work and
others it didn't. I'm not sure why that happened, but the solution was to
install an older printer driver. After that, the grid lines were fine.

Jeff
 
J

Jon Peltier

Any fill in the cells will obscure the gridlines. But you can apply borders
for the same effect.

- Jon
 
Top