gridlines

S

sis5362

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.
 
D

David Billigmeier

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)
 
D

David Billigmeier

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
 
S

sis5362

Thanks that worked.

David Billigmeier said:
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
Click to expand...
 
S

sis5362

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

David McRitchie said:
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 said:
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.
Click to expand...
Click to expand...
 
D

David Billigmeier

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

--
Regards,
Dave


David McRitchie said:
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 said:
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.
Click to expand...
Click to expand...
 
G

Gord Dibben

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


Gord Dibben Excel MVP
 
D

David McRitchie

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

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

--
Regards,
Dave


David McRitchie said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Top