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

[Guest]

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?

 

[Ragdyer]

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

 

[Cutter]

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

 

[Guest]

How do you do this formatting?

 

[Gord Dibben]

Fran

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


Gord Dibben Excel MVP

 

[Guest]

Ok, I'll give it a try.

Thanks.

Fran

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


Gord Dibben Excel MVP

 

[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

 

[Jon Peltier]

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

- Jon