Excel 2002...adding back gridlines to imported file

  • Thread starter Thread starter jbclem
  • Start date Start date
J

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
 
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
 
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
 
I'd already checked that, it was set to automatic so I reset it to
black...but still no gridlines.

jc
 
You reset the cells' background color to Black?

No wonder you can't see gridlines.


Gord
 
Back
Top