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

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?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Fran Jones" <Fran wrote in message
...
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?

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401758

How do you do this formatting?

"Cutter" wrote:


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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401758

Fran

Select all cells then FormatCellsPatternsNo Color


Gord Dibben Excel MVP

On Sun, 4 Sep 2005 10:34:03 -0700, "Fran Jones"
wrote:


How do you do this formatting?

"Cutter" wrote:


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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401758

Ok, I'll give it a try.

Thanks.


"Gord Dibben" wrote:

Fran

Select all cells then FormatCellsPatternsNo Color


Gord Dibben Excel MVP

On Sun, 4 Sep 2005 10:34:03 -0700, "Fran Jones"
wrote:


How do you do this formatting?

"Cutter" wrote:


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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401758

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

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

"Fran Jones" wrote:

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?

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JNelson" wrote in message
...
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

"Fran Jones" wrote:

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?