Excel 2002...adding back gridlines to imported file

[jbclem]

I've been switching from Quattro Pro 9 to Excel 2002, and I just saved
Quattro Pro file(.qpw) as an .xls file. Then I moved it to my .xls folder
and opened it with Excel 2002. Everything seems to be ok except that the
gridlines are missing. I looked in the Excel Tools/Options/View and the
gridlines choice is checked. I'm not sure what to do next to get the
gridlines back into this spreadsheet. Any suggestions?

jc

 

[Elkar]

Check to see if the Gridline Color has been changed to match the background.
In the TOOLS-->OPTIONS-->VIEW Tab, just below the Gridlines checkbox, there
should be a setting for Gridline Color. Try changing this to see if it makes
a difference.

If not that, then check to see if the Cell Borders have been set to the same
color as the background. FORMAT-->CELLS-->BORDER Tab. Try removing all
borders and see if that helps.

HTH,
Elkar

 

[Gord Dibben]

Check that cell backgrounds are formatted to "No Color" or Automatic.

Could be they are currently White which blocks out gridlines.


Gord Dibben MS Excel MVP

 

[jbclem]

I'd already checked that, it was set to automatic so I reset it to
black...but still no gridlines.

jc

 

[Gord Dibben]

You reset the cells' background color to Black?

No wonder you can't see gridlines.


Gord