Excel 2002...adding back gridlines to imported file
 

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

Excel 2002...adding back gridlines to imported file
 

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


"jbclem" wrote:

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

Excel 2002...adding back gridlines to imported file
 

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


On Thu, 1 Feb 2007 16:42:04 -0800, "jbclem" wrote:

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

Excel 2002...adding back gridlines to imported file
 

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

jc



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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


On Thu, 1 Feb 2007 16:42:04 -0800, "jbclem" wrote:

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

Excel 2002...adding back gridlines to imported file
 

You reset the cells' background color to Black?

No wonder you can't see gridlines.


Gord

On Fri, 2 Feb 2007 01:19:51 -0800, "jbclem" wrote:

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

jc



"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
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


On Thu, 1 Feb 2007 16:42:04 -0800, "jbclem" wrote:

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