GRID LINES PROBLEM iN EXCEL 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have have changed or confirmed all settings in Options and Page Setup to
accommondate Grid Lines and for some reason the Grid Lines or not displaying
on the Page Setup View nor do they Print.

I tried to change the default color (Light Blue) to Black but only change
was in areas of the chart that are not being used.
 
Caroken

Perhaps you have changed the background of those cells from "no color" or
"automatic", which is default, to white, which hides the gridlines.


Gord Dibben Excel MVP
 
Caroken

If you are using a background colour to your cells then this overwrites the
'built-in' gridlines. You will have to manually apply cell borders if this
is the case

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Gord Dibben said:
Caroken

Perhaps you have changed the background of those cells from "no color" or
"automatic", which is default, to white, which hides the gridlines.


Gord Dibben Excel MVP



Hi, And thanks for replying. I checked the settings you spoke of and they are in the Default mode. Personally, I have done just about everything I can think of.
Does this forum allow imbedded images because I have screen shot which I can
show what I'm looking at.
 
Caroken

Send the entire file to my email if you wish. Not the screenshot, the
workbook.

Change the AT and DOT as appropriate.


Gord
 
Gord Dibben said:
Caroken

Send the entire file to my email if you wish. Not the screenshot, the
workbook.

Change the AT and DOT as appropriate.


Gord
______________________________________________________________

Just Sent the file ... Thank You
 
Nick Hodge said:
Caroken

If you are using a background colour to your cells then this overwrites the
'built-in' gridlines. You will have to manually apply cell borders if this
is the case

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Nick Hodge said:
Caroken

If you are using a background colour to your cells then this overwrites the
'built-in' gridlines. You will have to manually apply cell borders if this
is the case

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
____________________________________________________________________

No never changed the Background settings from time of 1st install
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top