why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

First, make sure you have the gridlines selected to print... File-Page
Setup-'Sheet' Tab-Select 'Gridlines'

Second, Tools-Options-'View' Tab-Change the gridlines color (last option,
on the bottom)


--
Regards,
Dave


"sis5362" wrote:

why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

I have done that, but it still prints the light grey, instead of black.

"David Billigmeier" wrote:

First, make sure you have the gridlines selected to print... File-Page
Setup-'Sheet' Tab-Select 'Gridlines'

Second, Tools-Options-'View' Tab-Change the gridlines color (last option,
on the bottom)


--
Regards,
Dave


"sis5362" wrote:

why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

Gridlines are gray, don't confuse gridlines with borders.
You can set the color, and thickness of borders as well as being
solid or various dotted forms.

Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"sis5362" wrote in message ...
why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

Maybe it just appears grey because the lines are so thin, try making them
thicker by selecting the range your data is in and going into
Format-Cells-'Border' tab

--
Regards,
Dave


"sis5362" wrote:

I have done that, but it still prints the light grey, instead of black.

"David Billigmeier" wrote:

First, make sure you have the gridlines selected to print... File-Page
Setup-'Sheet' Tab-Select 'Gridlines'

Second, Tools-Options-'View' Tab-Change the gridlines color (last option,
on the bottom)


--
Regards,
Dave


"sis5362" wrote:

why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

Thanks that worked.

"David Billigmeier" wrote:

Maybe it just appears grey because the lines are so thin, try making them
thicker by selecting the range your data is in and going into
Format-Cells-'Border' tab

--
Regards,
Dave


"sis5362" wrote:

I have done that, but it still prints the light grey, instead of black.

"David Billigmeier" wrote:

First, make sure you have the gridlines selected to print... File-Page
Setup-'Sheet' Tab-Select 'Gridlines'

Second, Tools-Options-'View' Tab-Change the gridlines color (last option,
on the bottom)


--
Regards,
Dave


"sis5362" wrote:

why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

Thank you, was able to make it work with the borders.

"David McRitchie" wrote:

Gridlines are gray, don't confuse gridlines with borders.
You can set the color, and thickness of borders as well as being
solid or various dotted forms.

Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"sis5362" wrote in message ...
why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

David -
Gridlines aren't necessarily always grey, you can change them to a different
color under Tools-Options-'View' Tab

--
Regards,
Dave


"David McRitchie" wrote:

Gridlines are gray, don't confuse gridlines with borders.
You can set the color, and thickness of borders as well as being
solid or various dotted forms.

Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"sis5362" wrote in message ...
why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

Regular gridlines will also print as black if you are set for "black and
white" in Print options.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 13:31:02 -0700, "sis5362"
wrote:

Thanks that worked.

"David Billigmeier" wrote:

Maybe it just appears grey because the lines are so thin, try making them
thicker by selecting the range your data is in and going into
Format-Cells-'Border' tab

--
Regards,
Dave


"sis5362" wrote:

I have done that, but it still prints the light grey, instead of black.

"David Billigmeier" wrote:

First, make sure you have the gridlines selected to print... File-Page
Setup-'Sheet' Tab-Select 'Gridlines'

Second, Tools-Options-'View' Tab-Change the gridlines color (last option,
on the bottom)


--
Regards,
Dave


"sis5362" wrote:

why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.

Thanks, I'll have to check and probably change my web page,
I remember seeing that option now <grin
..

"David Billigmeier" wrote in message
...
David -
Gridlines aren't necessarily always grey, you can change them to a different
color under Tools-Options-'View' Tab

--
Regards,
Dave


"David McRitchie" wrote:

Gridlines are gray, don't confuse gridlines with borders.
You can set the color, and thickness of borders as well as being
solid or various dotted forms.

Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"sis5362" wrote in message ...
why can't I get the gridlines to print in a darker color, such as black. I
can change them but they won't print that way.