ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   GRID LINES PROBLEM iN EXCEL 2003 (https://www.excelbanter.com/excel-worksheet-functions/51830-grid-lines-problem-excel-2003-a.html)

Caroken

GRID LINES PROBLEM iN EXCEL 2003
 
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.

Gord Dibben

GRID LINES PROBLEM iN EXCEL 2003
 
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

On Sun, 23 Oct 2005 11:29:02 -0700, "Caroken"
wrote:

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.



Nick Hodge

GRID LINES PROBLEM iN EXCEL 2003
 
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
HIS


"Caroken" wrote in message
...
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

GRID LINES PROBLEM iN EXCEL 2003
 


"Gord Dibben" wrote:

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

On Sun, 23 Oct 2005 11:29:02 -0700, "Caroken"
wrote:

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.


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.


Gord Dibben

GRID LINES PROBLEM iN EXCEL 2003
 
Caroken

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

Change the AT and DOT as appropriate.


Gord


On Sun, 23 Oct 2005 15:31:03 -0700, "Caroken"
wrote:



"Gord Dibben" wrote:

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

On Sun, 23 Oct 2005 11:29:02 -0700, "Caroken"
wrote:

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.


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

GRID LINES PROBLEM iN EXCEL 2003
 


"Gord Dibben" wrote:

Caroken

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

Change the AT and DOT as appropriate.


Gord


On Sun, 23 Oct 2005 15:31:03 -0700, "Caroken"
wrote:



"Gord Dibben" wrote:

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

On Sun, 23 Oct 2005 11:29:02 -0700, "Caroken"
wrote:

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.

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.

__________________________________________________ ____________

Just Sent the file ... Thank You


Caroken

GRID LINES PROBLEM iN EXCEL 2003
 


"Nick Hodge" wrote:

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
HIS


"Caroken" wrote in message
...
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

GRID LINES PROBLEM iN EXCEL 2003
 


"Nick Hodge" wrote:

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
HIS


"Caroken" wrote in message
...
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.


__________________________________________________ __________________

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


All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com