View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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